Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box Code...
Hey guys, I need some help...I have worksheet that currently holds data for different classes. What I plan to do is to have a combo box (2 item in the list) that allows me to switch between the data (i.e. from clas I to Class II, all the Class I data is hidden and all the Class II dat appears). Furthermore, the worksheet layout for each class i identical, this is why I want to add this feature, because it would b much more convienent for me to have a link to access either clas through the combo box instead of having both Class listed next to eac other. If there are any other suggestions, besides using a combo box, pleas let me know also. Thanks for the help in advanced! -- younatha ----------------------------------------------------------------------- younathan's Profile: http://www.excelforum.com/member.php...fo&userid=1541 View this thread: http://www.excelforum.com/showthread.php?threadid=27021 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box Code...
If you're talking about a list of mixed data, like Col A is a mix of Class 1
and Class 2 items, then you might consider doing an autofilter (Data, AutoFilter). This will allow you to select your criteria from down downs and see only the records that match them. -- Jim Rech Excel MVP "younathan" wrote in message ... | | Hey guys, | | I need some help...I have worksheet that currently holds data for 2 | different classes. What I plan to do is to have a combo box (2 items | in the list) that allows me to switch between the data (i.e. from class | I to Class II, all the Class I data is hidden and all the Class II data | appears). Furthermore, the worksheet layout for each class is | identical, this is why I want to add this feature, because it would be | much more convienent for me to have a link to access either class | through the combo box instead of having both Class listed next to each | other. | | If there are any other suggestions, besides using a combo box, please | let me know also. | | Thanks for the help in advanced!! | | | -- | younathan | ------------------------------------------------------------------------ | younathan's Profile: http://www.excelforum.com/member.php...o&userid=15415 | View this thread: http://www.excelforum.com/showthread...hreadid=270212 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo Box Code | Excel Discussion (Misc queries) | |||
Combo Box Code | Excel Discussion (Misc queries) | |||
Combo Box Standard code | Excel Programming | |||
Combo Box code | Excel Programming | |||
Help with Combo Box code | Excel Programming |