| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Use text from a cell reference in vba code.
I have a combobox on the first sheet of a workbook. I’m using it to jump to selected pages as there is close to 100 sheets. All selections in the combobox dropdown menu, except one, are sheet names so that part of the vba code is simple.
I’ve used Code:
Private Sub ComboBox1_Change()
If ComboBox1.Value = "Statistics" Then
Sheets("Statistics").Select
End If
The exception in the dropdown menu is called ‘Current Day’. Each sheet has a unique date. I want to be able to jump to the sheet associated with the current day. I’m using the ‘vlookup’ function followed by ‘Today()’ to give me the sheet name relating to the current date in cell ‘Sheet 1!$AH$130’. The combobox linked cell is ‘Sheet1!$AE$128’ Could someone please give me a few pointers, as I am unsure of where to go from here. Thanks. |
|
#2
|
|||
|
|||
|
Quote:
Probably easier to use an exclusion for the values that are NOT Sheet Names. Then replace your sheet finder code with Sheets(ComboBox1.value).select or similar. David |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA code for find function (reference cell value) | Excel Worksheet Functions | |||
| vb code for renaming a work sheet with a cell reference | Excel Discussion (Misc queries) | |||
| What is the Chr() code for Alt+Enter in a cell when entering text? | Excel Discussion (Misc queries) | |||
| Code to get text from part of a cell | Excel Worksheet Functions | |||
| How can I reference data or text within a text box to a cell in Ex | Excel Discussion (Misc queries) | |||
Linear Mode
