Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Go To Button on a spreadsheet.
I have the following code that i cannot get to work. In escence i
just want to click on the button and go to the worksheet named in the combobox. If i take the combobox away and just type a name into a cell say A4 it works fine. Obviously i am not referencing the Combobox properly. Private Sub CommandButton1_Click() Worksheets(Range("ComboBox1").Value).Activate End Sub With thanks Bob |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Go To Button on a spreadsheet.
Try this
Private Sub ComboBox1_Change() Sheets(ComboBox1.Text).Select End Sub Mike "Bob" wrote: I have the following code that i cannot get to work. In escence i just want to click on the button and go to the worksheet named in the combobox. If i take the combobox away and just type a name into a cell say A4 it works fine. Obviously i am not referencing the Combobox properly. Private Sub CommandButton1_Click() Worksheets(Range("ComboBox1").Value).Activate End Sub With thanks Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a button on a spreadsheet ? | Excel Worksheet Functions | |||
Reset button in my spreadsheet | Excel Discussion (Misc queries) | |||
Can you add a button to a spreadsheet to Print? | Excel Discussion (Misc queries) | |||
Button to email my spreadsheet | Excel Discussion (Misc queries) | |||
Adding a button to a spreadsheet... | Excel Discussion (Misc queries) |