snoozee
Thread Starter
- Joined
- Apr 10, 2006
- Messages
- 272
HI
I have a UserForm that has a ComboBox and a CommandButton. The data in the ComboBox varies depending on what the user has typed, However no matter what "shows" it links to a certain worksheet.
Example
ComboBox shows "Management" this would link to a worksheet called "Quarter1".
What I need to try and work out is how to code the CommandButton so that if the user chooses "Management" then the WorkSheet "Quarter1" would open.
Any help would be greatly appreciated
I have a UserForm that has a ComboBox and a CommandButton. The data in the ComboBox varies depending on what the user has typed, However no matter what "shows" it links to a certain worksheet.
Example
ComboBox shows "Management" this would link to a worksheet called "Quarter1".
What I need to try and work out is how to code the CommandButton so that if the user chooses "Management" then the WorkSheet "Quarter1" would open.
Any help would be greatly appreciated