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?

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?

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?