moshehadar
01-29-2013, 04:31 AM
See attached file.
On "Club_members_list" sheet press the "new" button (userform2)
There is Email validation function called "emailTest"
as working now it have a message but it still put the wrong email adress in place.
I need it to make the user change to valid email adress before finish the form.
Also i apreciate if you have any solution to validate the cellphone number
it should have 10 digits like-"054-6702277"
Can the user input 0546702277 and get "054-6702277" ?
br
Moshe.
On "Club_members_list" sheet press the "new" button (userform2)
There is Email validation function called "emailTest"
as working now it have a message but it still put the wrong email adress in place.
I need it to make the user change to valid email adress before finish the form.
Also i apreciate if you have any solution to validate the cellphone number
it should have 10 digits like-"054-6702277"
Can the user input 0546702277 and get "054-6702277" ?
br
Moshe.