How to change combobox listfillrange using macros?

J

John

I have 6 different comboboxes on sheet1 all of which reference the same range
on sheet2. I would like to set them up so that if only the fourth choice
(john) is selected then the other 5 will not allow the user to select "john".

Right now I have it set up like this for each of the 6 boxes. R11 is "john".

If ccombobox1 = "John" then
CComboBox2.ListFillRange = ("stats!R7:R10")
CComboBox3.ListFillRange = ("stats!R7:R10")
CComboBox4.ListFillRange = ("stats!R7:R10")
CComboBox5.ListFillRange = ("stats!R7:R10")
CComboBox6.ListFillRange = ("stats!R7:R10")
End If
 
K

Ken Snell [MVP]

This appears to be a question related to EXCEL. This newsgroup is for
ACCESS. I suggest that you post your question in one of the EXCEL
newsgroups.
 

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

Adding a VLookup to an AutoComplete ComboBox 0
Can Listfillrange be used with a listbox or combobox on a form? 2
ListFillRange 4
Transpose technique not populating ListFillRange of ActiveX combobox 2
Changing the value in one ComboBox also changes the value of anoth 1
populate combobox from worksheet in different workbook 3
extracting data from columns to summary sheet 0
Excel 2007 - How to get cell referrences from dates in combobox 3

Top