Combo box

[Scott Jacobs]

Without using data validation, is there any way to dynamically define a
range for a combo box placed on a worksheet from the "forms" tool bar?
Meaning that the range for the combo box needs to increase as more data is
added to the spreadsheet. If not, if I were to add a combo box to the
worksheet from the "control toolbox" how do I get the combobox to add a cell
link to the spreadsheet so I can query the data based on the selection in
the combobox.

Please provide sample code.

Any help is greatly appreciated!!!

Thanks,

Scott J

 

[Bob Phillips]

If you use a dynamic named range, you can link the combo to that range. For
example

Insert>Name>Define Name...
name of say myRange
RefersTo of say =$A$1:OFFSET($A$1,,,COUNTA($A:$A))

On the combo, right-click and select Format Control, on the Control tab set
the Link range to myRange

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Scott J]

Bob,

Thanks a lot, this works perfectly. I really appreciate the help.

Scott J