ComboBox - Changing ListFillRange

  • Thread starter Thread starter colin.sidwell
  • Start date Start date
C

colin.sidwell

Can anyone tell me if there is any way that I can change
the ListFillRange or LinkedCell of a Combo Box which is on
a WORKSHEET NOT, REPEAT NOT on a FORM via a macro
 
ActiveSheet.ComboBox1.ListFillRange = "C3:C10"


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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

Problem when Combo box has linked cell as a number 4
Can Listfillrange be used with a listbox or combobox on a form? 2
Data Validation - Combo Box open with single click 0
Combo Box Values Not Sticking & Mult/ Combo Boxes in a WorkSheet 1
Change properties of a combobox with VBA 0
refresh combobox 2
Rename combobox with a macro 1
combo box 1

Back
Top