Hi
I've set up a user form which gives you the option of 12 items. What I want to do is depending on which one is selected, that when you press ok, it goes to the tab name that's been selected.
For example.
Tab list - P1 P2 P3 P4
If P1 is selected it goes to the tab named P1
Any help welcome!
What does your form look like? How is a Tab selected. What are the 12 options. More information is needed. Perhaps if you uploaded a sample workbook that is representative of your data it would result in a quick solution
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
The form Capture.JPG
The tabs are named P1, P2, P3, P4, P5 as per the list shown up to P12.
Simply I want to be able to select a tab name from the list and when I select "OK" for the spreadsheet to goto the tab name selected.
Try this untested code. Attach it to your OK Button. You may have to change the control name combox1 to what ever your control is called. Since you only supplied a picture and not a file (as requested), I could not test nor use your nomenclature.
Please Login or Register to view this content.
Sorry I'm having issues uploading file for some reason, hence the image. When I'm going to attach file it doesn't give me any options just a narrow white box. Believe we have been having internet issues all day.
I might have to come back to this in the morning.
Sorry to be a pain.
****Follow up! Appears to have attached!
Add a command button to your sheet. Place this code on the button
Assign this code to your OK button on the formPlease Login or Register to view this content.
Please Login or Register to view this content.
Many thanks for your help!
That works perfectly!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks