VBA code to get 3 IF statement to work

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

Hi.
Try this
replace below NamedRange with your actual name

Please Login or Register  to view this content.

Thank you naveenmarapaka but that also does not work, it will work with 1 Combobox but when you use (And) and add 2 more into the IF statement it fails to work

Post your sample data

Sample Data Attached

Check this...

Great, thank you, one last thing if I clicked on an item in the Listbox how could I retrieve the data from the row of the item listed ? put into textboxes on userform?
Thank you for your help

Hi.
You binded your Macro to a limited range of data selection...

I believe basically you want program as attached... Test it fully.....and let me know....



1 Click on the star if you think some-1 helped you
2. If your question is resolved, mark it SOLVED using the thread tools

You make it look so easy, Thank you very much

Glad it helped you

Hi naveenmarapaka

Hope you can help again

Hi. Ken, Slightly modified ... still please specify your requirement....

it is pulling the data from the wrong row, not current row, Please see Attached file with requirements,hope it is a bit more clear, thank you

Cut this line of code

Please Login or Register  to view this content.

at the bottom
in Prscss_click() module...
and paste at Prscss_click() module starting and check .....

yes that is now working thank you for your time

You are Welcome