Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help
I have a dialog box that I am using to pull up a specific sheet in my
workbook. It has 2 option buttons, one for week 1 and one for week 2, then it has a dropdown for the day of the week. I then use the concatenate command to combine the day and the week in the ref cell. My question is... How do I get the sheet that the cell name is referenced to open when I click the OK button? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help
For the active workbook
Worksheets("MySheet").Activate Or, being workbook-specific Workbooks("Book1.xls").Worksheets("MySheet").Activ ate Bob "justaguyfromky" wrote in message ... I have a dialog box that I am using to pull up a specific sheet in my workbook. It has 2 option buttons, one for week 1 and one for week 2, then it has a dropdown for the day of the week. I then use the concatenate command to combine the day and the week in the ref cell. My question is... How do I get the sheet that the cell name is referenced to open when I click the OK button? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help
What I want it to do is...
Worksheets (A1).Activate How can I get this to work Thanks "Bob Kilmer" wrote: For the active workbook Worksheets("MySheet").Activate Or, being workbook-specific Workbooks("Book1.xls").Worksheets("MySheet").Activ ate Bob "justaguyfromky" wrote in message ... I have a dialog box that I am using to pull up a specific sheet in my workbook. It has 2 option buttons, one for week 1 and one for week 2, then it has a dropdown for the day of the week. I then use the concatenate command to combine the day and the week in the ref cell. My question is... How do I get the sheet that the cell name is referenced to open when I click the OK button? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help
Hi,
Say A1 (contraining the sheet name to activate) is in the active sheet: Worksheets(Range("A1").Text).Activate Else, say A1 is in 'Sheet1' Worksheets(Worksheets("Sheet1").Range("A1").Text). Activate Regards, Sébastien "justaguyfromky" wrote: What I want it to do is... Worksheets (A1).Activate How can I get this to work Thanks "Bob Kilmer" wrote: For the active workbook Worksheets("MySheet").Activate Or, being workbook-specific Workbooks("Book1.xls").Worksheets("MySheet").Activ ate Bob "justaguyfromky" wrote in message ... I have a dialog box that I am using to pull up a specific sheet in my workbook. It has 2 option buttons, one for week 1 and one for week 2, then it has a dropdown for the day of the week. I then use the concatenate command to combine the day and the week in the ref cell. My question is... How do I get the sheet that the cell name is referenced to open when I click the OK button? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help
Whoa! Sorry for my brain dead answer. Your question is perfectly clear. I
shouldn't sleep while I post, I guess. "justaguyfromky" wrote in message ... What I want it to do is... Worksheets (A1).Activate How can I get this to work Thanks "Bob Kilmer" wrote: For the active workbook Worksheets("MySheet").Activate Or, being workbook-specific Workbooks("Book1.xls").Worksheets("MySheet").Activ ate Bob "justaguyfromky" wrote in message ... I have a dialog box that I am using to pull up a specific sheet in my workbook. It has 2 option buttons, one for week 1 and one for week 2, then it has a dropdown for the day of the week. I then use the concatenate command to combine the day and the week in the ref cell. My question is... How do I get the sheet that the cell name is referenced to open when I click the OK button? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |