Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form
OK, a newbie at UserForms in Excel. I want to make 2 combo boxes in Excel.
One has a named range which uses the data from the worksheet, which I figured out, but when an item is chosen in the first combo, I want it to requery and have a new list of items. What do I do to make this happen. If Column 1 has Value1, Value2 in the data, then the 1st combo fills with Value1 and Value2. Also, Column1 in the worksheet looks like this: Column1 Value1 Value2 Then I have in Columns 2 and 3 the following, which I think I have to do to represent what data to use for the 2nd combo. Column2 Column3 Value1 A Value1 B Value1 C Value2 AA Value2 BB Value2 CC So how do I choose Value1 in the first combo (which reads from Column1), and then have it show A,B,C in the 2nd combo? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Call user form from ThisWorkbook; close file if form closed | Excel Programming | |||
Automatically add a textbox to a user form based on user requireme | Excel Programming | |||
User form ComboBox Items: Remember user entries? | Excel Programming | |||
How to: User Form to assign a user defined range to a macro variab | Excel Programming |