Combo Box Row source problem

R

ranswert

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
 
G

Greg Wilson

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
 
R

ranswert

I think that will works.
Thanks alot
Greg Wilson said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top