H
homeseal
Hi people! Please help!
I've got a problem with VBA user form validation. I have a form whic
takes values and inputs them into a spreadsheet when a submit button i
clicked. But I want the submit button to first check:
If
The first Name + Last Name in a cell = First Name(ColumnA) + Last Nam
(ColumnB)
then
MsgBox "Name already exists"
and or
If SSN in a cell = SSN (ColumnC)
then
MsgBox "SSN already exists"
and the saving to the spreadsheet to stop.
How can I get this done? I've checked everywhere!
Please help
I've got a problem with VBA user form validation. I have a form whic
takes values and inputs them into a spreadsheet when a submit button i
clicked. But I want the submit button to first check:
If
The first Name + Last Name in a cell = First Name(ColumnA) + Last Nam
(ColumnB)
then
MsgBox "Name already exists"
and or
If SSN in a cell = SSN (ColumnC)
then
MsgBox "SSN already exists"
and the saving to the spreadsheet to stop.
How can I get this done? I've checked everywhere!
Please help