Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box Row source problem
I have been having a problem with the row source on a combo box. I have the
range named 'drwlistrng' for the row source. I have a procedure that adds items to the range and in that procedure the named range adds the row to the rangename. When combo box list is pulled up the the last item added to the range does not come up. I will go in the name box and select 'drwlistrng' and the full range is highlighted. I can't figure out what is wrong. Any Ideas? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box Row source problem
My assumption is that you are refering to a combobox on a userform since the
terms ListFillRange and Input Range are used for ComboBoxes on a worksheet respectively from the Control Toolbox toolbar and Forms toolbar. In the routine that adds to the range, after making the addition, update the combobox by running this: ComboBox1.RowSource = "drwlistrng" Obviously, change the name of the combobox to suit. Greg "ranswert" wrote: I have been having a problem with the row source on a combo box. I have the range named 'drwlistrng' for the row source. I have a procedure that adds items to the range and in that procedure the named range adds the row to the rangename. When combo box list is pulled up the the last item added to the range does not come up. I will go in the name box and select 'drwlistrng' and the full range is highlighted. I can't figure out what is wrong. Any Ideas? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box Row source problem
I think that will works. Thanks alot "Greg Wilson" wrote: My assumption is that you are refering to a combobox on a userform since the terms ListFillRange and Input Range are used for ComboBoxes on a worksheet respectively from the Control Toolbox toolbar and Forms toolbar. In the routine that adds to the range, after making the addition, update the combobox by running this: ComboBox1.RowSource = "drwlistrng" Obviously, change the name of the combobox to suit. Greg "ranswert" wrote: I have been having a problem with the row source on a combo box. I have the range named 'drwlistrng' for the row source. I have a procedure that adds items to the range and in that procedure the named range adds the row to the rangename. When combo box list is pulled up the the last item added to the range does not come up. I will go in the name box and select 'drwlistrng' and the full range is highlighted. I can't figure out what is wrong. Any Ideas? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find/edit combo box source? | New Users to Excel | |||
Combo box Row source | Excel Programming | |||
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) |