Hi,
I am working with a multipage userform. There are 10 pages of data entry form and all the data goes into a sheet called DataSheet.
Can some one pls help me fix the following code:
If (ISERROR(MATCH(NameBox.Value,DataSheet!R1,0)),0,1) = 0 then
MsgBox ("Duplicate entry, click database to modify the entry!")
NameBox.SetFocus 'Place them back in
Exit Sub
Using the above code, I am trying to set up a rule to see if the name in the NameBox field of the userform already existing in Range (1:1) of the DataSheet.
and if the name is already present in the range show the message otherwise proceed.
Hope it makes sense.
Thanks in advance,
I am working with a multipage userform. There are 10 pages of data entry form and all the data goes into a sheet called DataSheet.
Can some one pls help me fix the following code:
If (ISERROR(MATCH(NameBox.Value,DataSheet!R1,0)),0,1) = 0 then
MsgBox ("Duplicate entry, click database to modify the entry!")
NameBox.SetFocus 'Place them back in
Exit Sub
Using the above code, I am trying to set up a rule to see if the name in the NameBox field of the userform already existing in Range (1:1) of the DataSheet.
and if the name is already present in the range show the message otherwise proceed.
Hope it makes sense.
Thanks in advance,
