| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo box Row source
Hello,
Hope, someone can help me here. Since I only have 3 list the I want user to select it from the conbo box, I want to type list of combox data in the "RowSource" in the Property. How can I do this? Anyone can help me out here? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combo box Row source
Try the .AddItem method to assign the values
RowSource can only be a cell reference back to an excel worksheet or range name. -- Regards, John "Richard" wrote: Hello, Hope, someone can help me here. Since I only have 3 list the I want user to select it from the conbo box, I want to type list of combox data in the "RowSource" in the Property. How can I do this? Anyone can help me out here? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combo box Row source
Instead of using a combobox, you may want to look at Data|Validation. It's much
easier to implement and acts kind of like a combobox. Debra Dalgleish has lots of tips: http://contextures.com/xlDataVal01.html Richard wrote: Hello, Hope, someone can help me here. Since I only have 3 list the I want user to select it from the conbo box, I want to type list of combox data in the "RowSource" in the Property. How can I do this? Anyone can help me out here? Thanks -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find/edit combo box source? | New Users to Excel | |||
| Combo Source from another file | Excel Programming | |||
| Variable row data source for combo boxes? | Excel Programming | |||
| Source code for combo box in form | Excel Discussion (Misc queries) | |||
| Need One combo box row source to change based on the value of anot | Excel Programming | |||
Linear Mode
