named range

G

geebee

hi,

i have the following to set the listfillrange of a combobox (forms
combobox). but it is not working:

Sheets("template").ComboBox1.Range ("num_dropdown")
any ideas?

thanks in advance,
geebee
 
F

FSt1

hi
is the forms combo box on the sheet????
if so you wont be able to set it. you would need a sheet combo box from the
control tool box. then use this code.
Sub setlfr()
Dim r As Range
Set r = Sheets("sheet2").Range("Num_DropDown")
ComboBox1.ListFillRange = r.Address
End Sub
iis the list fill range on another sheet than the combobox?
if so use this
ComboBox1.ListFillRange = r.Address(External:=True)

post back if i have mis understood.
Regards
FSt1
 
F

FSt1

oh
forgot to mention. the forms combo box doesn't have a list fill range. it
has row source.

regards
FSt1
 

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

Similar Threads


Top