One thing is holding me back from buying the new Surface tablet. I want to be able to use the scroll bar created within Excel's Userform. I want to be able to touch the scroll bar with my finger, slide the ends up and down through the list of items, or touch in the middle of the scrollbar to jump quickly around in the list. In other words, I want it to work just like it does on the desktop. And please note....I am NOT talking about the scrollbar on the side of the screen within Excel. I know that works. I'm talking about the Userform capability where one can create a box populated with items that will trigger other events depending on which item is selected.
This capability has been questioned before in other threads both in thus forum and others. The replies provide conflicting answers so I don't know whether you can do it or not. One person will say It can be done, and another will say it cannot. I'm not eager to waste $500 to find out which answer was right.
So, if someone definitely knows the answer, perhaps has even made a scrollbar using the userform capability within Microsoft Excel, would they take a moment to convince me it can or cannot be done? It sure would be appreciated. And if it isn't clear what I'm asking please let me know.
Thanks. I really hope this can work because I have $500 burning a hole in my pocket.
This capability has been questioned before in other threads both in thus forum and others. The replies provide conflicting answers so I don't know whether you can do it or not. One person will say It can be done, and another will say it cannot. I'm not eager to waste $500 to find out which answer was right.
So, if someone definitely knows the answer, perhaps has even made a scrollbar using the userform capability within Microsoft Excel, would they take a moment to convince me it can or cannot be done? It sure would be appreciated. And if it isn't clear what I'm asking please let me know.
Thanks. I really hope this can work because I have $500 burning a hole in my pocket.