E
Eduardo
Hi and thank you in advance for your help
How do I write an statement that use if and with vba. here is what I need to
do,
I have information saved in one sheet "Projects" with 4 columns, Client,
Project name, Project # and Business. then I have and userform to to apply
expenses against each project so I need to compare the information enter in
each textbox with the columns in the data base if one of them doesn't match a
message will show up and will not allow the user to continue until is fixed.
an example will be
Client= A
Project name = A1
Project # = 1
Business = APP
so in order to apply anything to project # 1 all the others fields entered
have to match A, A1 & APP
I am thinking in something like,
if(and(textbox1=A:A, textbox2=B:B, textbox3=C:C, textbox4=D) then
Else
msgbox = " Information doesn't belong to project #"
How do I write an statement that use if and with vba. here is what I need to
do,
I have information saved in one sheet "Projects" with 4 columns, Client,
Project name, Project # and Business. then I have and userform to to apply
expenses against each project so I need to compare the information enter in
each textbox with the columns in the data base if one of them doesn't match a
message will show up and will not allow the user to continue until is fixed.
an example will be
Client= A
Project name = A1
Project # = 1
Business = APP
so in order to apply anything to project # 1 all the others fields entered
have to match A, A1 & APP
I am thinking in something like,
if(and(textbox1=A:A, textbox2=B:B, textbox3=C:C, textbox4=D) then
Else
msgbox = " Information doesn't belong to project #"