List boxes with Surface Pro

How will the Surface Pro handle list boxes in Excel? I'm hoping that the user will be able to simply touch an item in the list box and have the associated VBA code execute (the same way it works in Windows XP with the click of a mouse).

Along these lines, I've been told that the Surface RT does not run VBA macros in Excel. I assume the Surface Pro will. Is that assumption correct?

Yes, you are correct. Office on Surface RT is a great feature but it is not fully featured. Outlook and macros are the big missing features from Office on RT devices and you need Surface Pro (or any device Running Windows 8) and a full copy of Office for those.