Hi All,
I have a combo box that I would like to GO TO a specific cell based on a value in the list. Since I am struggling to describe what I'd like, I posted a very simple spreadsheet. For example, if "dogs" is selected in the drop down box, I'd like the cursor to automatically go to cell A39. Any help would be much appreciated.
-Scott
Attachment 356424
Try:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Olly, that worked well, but only when I go into VBA and click "run". Is there a way for it to automatically move across the sheet without having to open VBA? Is it an afterupdate on the combo box?
In your example workbook, your combobox is a Form control. Just assign the macro to the combobox - right click it, select "Assign Macro", choose the macro you want.
If it was an ActiveX combobox, you could just paste the code into the combobox_change event subroutine.
Worked perfectly - thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks