Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Goto specific sheet and cell
There are 13 sheets in the workbook. The first 12 sheets are contain 12
months records. Each month (sheet) has some different items record, they are my colleagues' recoed in that month. The 13th sheet is the summary (the last value of each item of each month). Now, I have created 2 ComboBox that one for selecting the month (which sheet) and one for item to view the detail of that item in that month after clicking a button. My question is, any effective way to name these sheets or any function to convert the index got from the combox to month name that I can use a for loop to go to the specific sheet? Another other problem for the item selection. e.g Jimmy's record is in the range "A4: A34", Ivan's record is in the range "A37: A64" ..etc. Is that the Goto Reference function is pointed to the "cell" only? can I point to the value of the cell to view the detail of the specific person? Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Goto specific sheet and cell
Just name the sheets Jan, Feb, etc and get the value from the combo, not the
index. Worksheets(Combobox1.Value).Activate -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "jimmy" wrote in message ... There are 13 sheets in the workbook. The first 12 sheets are contain 12 months records. Each month (sheet) has some different items record, they are my colleagues' recoed in that month. The 13th sheet is the summary (the last value of each item of each month). Now, I have created 2 ComboBox that one for selecting the month (which sheet) and one for item to view the detail of that item in that month after clicking a button. My question is, any effective way to name these sheets or any function to convert the index got from the combox to month name that I can use a for loop to go to the specific sheet? Another other problem for the item selection. e.g Jimmy's record is in the range "A4: A34", Ivan's record is in the range "A37: A64" ..etc. Is that the Goto Reference function is pointed to the "cell" only? can I point to the value of the cell to view the detail of the specific person? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to goto specific cell (todays date) | Excel Discussion (Misc queries) | |||
Goto a specific cell in a macro | Excel Discussion (Misc queries) | |||
How do I goto a specific Record in my Database? | Excel Programming | |||
Goto Specific Textbox in Userform | Excel Programming | |||
Goto Sheet based on Cell Value | Excel Programming |