Jer-XL-emy
Board Regular
- Joined
- Aug 27, 2007
- Messages
- 60
Hello,
I have a VBA-Crossword Puzzle for those who like them.
I am looking for a way to have two user input boxes pop-up upon opening the workbook, and depending on their selections, direct the user to the appropriate tab (worksheet).
If it easier to have it done with one input box, then that is fine with me.
Specifically, I have 6 tabs - 3 are different information and 2 of each of those are different formatting (one for print and one for onscreen) - so each (of 3) info tabs has 2 versions for a total of 6.
Thus, a user opens up the workbook and it asks them what information are they looking for?
and lists 3 options.
after they choose and hit ok another box opens up and ask them
"is this for print or onscreen viewing?"
with 2 options "Print" "On Screen"
Based on the two questions the macro takes them to an requested worksheet.
Any ideas - I really apprieciate your help and this message board
and thank you very much in advance
I have a VBA-Crossword Puzzle for those who like them.
I am looking for a way to have two user input boxes pop-up upon opening the workbook, and depending on their selections, direct the user to the appropriate tab (worksheet).
If it easier to have it done with one input box, then that is fine with me.
Specifically, I have 6 tabs - 3 are different information and 2 of each of those are different formatting (one for print and one for onscreen) - so each (of 3) info tabs has 2 versions for a total of 6.
Thus, a user opens up the workbook and it asks them what information are they looking for?
and lists 3 options.
after they choose and hit ok another box opens up and ask them
"is this for print or onscreen viewing?"
with 2 options "Print" "On Screen"
Based on the two questions the macro takes them to an requested worksheet.
Any ideas - I really apprieciate your help and this message board
and thank you very much in advance