Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Frames in Excel with drop down boxes.
I'm not sure of the best way to describe this so here's a picture;
http://i10.photobucket.com/albums/a1...untitled-1.jpg Basically, I have a combo-box with 13 selections in. Is it possible to view a different trip register in the rows 5-25? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Frames in Excel with drop down boxes.
Put all of the trip registers in rows 5 thru 277... (21 *13) rows. Add two more selections to the combobox... "All" and "None"...at the bottom. Then assign the following macro to the combobox. (assumes the combobox linked cell is A1) Note: the macro is incomplete in that, you must fill in the rest of the row designations for case 4 thru 13... -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware Sub ShowTheTripRegister() Dim lngTrip As Double lngTrip = ActiveSheet.Range("A1").Value Application.ScreenUpdating = False Rows("5:277").Hidden = True Select Case lngTrip Case 1 Rows("5:25").Hidden = False Case 2 Rows("26:46").Hidden = False Case 3 Rows("47:67").Hidden = False Case 4 Case 5 Case 6 Case 7 Case 8 Case 9 Case 10 Case 11 Case 12 Case 13 Case 14 'unhide all Rows.Hidden = False Case 15 'keep all hidden 'do nothing End Select Application.ScreenUpdating = True End Sub '------------ "Adam" wrote in message I'm not sure of the best way to describe this so here's a picture; http://i10.photobucket.com/albums/a1...untitled-1.jpg Basically, I have a combo-box with 13 selections in. Is it possible to view a different trip register in the rows 5-25? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Frames in Excel with drop down boxes.
http://www.cpearson.com/excel/newposte.htm
-- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Adam" wrote in message I'm not sure of the best way to describe this so here's a picture; http://i10.photobucket.com/albums/a1...untitled-1.jpg Basically, I have a combo-box with 13 selections in. Is it possible to view a different trip register in the rows 5-25? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Can I use drop down boxes in pocket excel? | Excel Discussion (Misc queries) | |||
excel timesheet and drop down boxes | Excel Discussion (Misc queries) | |||
how do i set up drop down menus to populate cells in excel? | Excel Discussion (Misc queries) | |||
A user says he can't get my drop down list to work in Excel. | Excel Discussion (Misc queries) |