I have successfully used Goto/Scroll code to jump to certain points in a very big table I have in one of the sheets of my workbook, however am having trouble applying it to a combobox selection.
Basically, my table starts at B8 (header row) and goes all the way down to AW8008. Column A contains the ID numbers for the names in the third column of the table. I have created a button enabled userform that contains a combobox ("CbxCity) listing all the ID numbers of these table names, and when one is selected I want the macro to jump to the matching ID number cell in column A of the worksheet.
Can anyone help me out with this? The code I have been playing with (but realize is never going to work) is:
Please Login or Register to view this content.
Bookmarks