Hi.
I'm starting to do a project on it and have numerous spreadsheets for clients, each tab named by 1, 2, 3 ... I want to create a form, which has a TEXTBOX and a BUTTON, where the customer would enter 2 in textbox and pressed the button, she went to that tab I typed.
Last edited by marreco; 10-11-2012 at 06:22 AM.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
marreco,
Can you clarify a few things? By spreadsheets and tabs named 1, 2, 3... do you mean one workbook (Excel file) with separate worksheets named 1, 2, 3, etc. or do you actually mean multiple workbooks (Excel files) named 1, 2, 3?
Also why not use a ComboBox with the values 1, 2, 3, etc. that the user can choose from? If you use the textbox method, what happens if you have 3 worksheets named 1, 2, and 3 and the user types "4" in the textbox? There is no corresponding sheet for them to go to.
Just trying to understand what you are trying to do.
Hi.
I have a file called 'Control'. Xls
Inside this file I have many tabs.
Guide call: 1, 2, 3 .....
when typing in a textbox the name of a dessaa guides, and press a command button, the macro will take me to a guide that was entered into the Textbox
Can you post a sample workbook?
Hi.
when typing the name of the tab in Textbox after pressing the button, the tab is selected
Please see the enclosed workbook. Let me know if this is what you are looking for.
The command button on each sheet (Guide 1, Guide 2, Guide 3) brings up the same UserForm. This form has one TextBox where the user can type something.
If what they type matches the name of one of the sheets then they are brought to that sheet. If not, they get an error message telling them what they typed doesn't match any of the sheets in the workbook.
Guide.xlsm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks