hi
Can someone point me in the right direction with a bit of code, I have 3 comboboxes and 1 listbox on a userform, the bit of VBA i want is to
look at what all 3 selections in the comboboxes so for example.....
Combobox1 = "word 1"
Combobox2 = "word 2"
Combobox3 = "word 3"
Listbox1 = a certain named range decided by the 3 words selected, I have tried IF statements but can not get 3 Ifs to work
all I am trying to achieve is
If Combobox1.value = "word 1" and Combobox.value = "word 2" and Combobox3.value = "word 3" then
Listbox1.Rowsource = certain named range
I have tried many variations for IF, And, Rowsource, ListFillRange
I seem to be struggling on something which I think is very simple
Thanks
J
Bookmarks