IF with AND

T

tigerdel

New member
Joined
Aug 23, 2012
Messages
40
Reaction score
0
Points
0
Location
Cambridgeshire
Excel Version(s)
Office 365
Hi All

I am try get a text box to contain a value based on the result of 2 comboboxes:

CmbRole contains text
CmbSDate contains a date

txtCourse needs a value based on the result of the value in both cells

have tried:

select_all_icon.jpg
page_white_copy.png


If CmbRole = "X" and CmbSDate = "Y" thenTxtCourse.value = "Z"
without any success

Any ideas??

Thanks

D
 
In what way was that not a success?
 
Then either CmbRole is not "X" or CmbSDate is not "Y".
 
You must log in or register to reply here.
Back
Top