How to change combobox listfillrange using macros?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top