pls help me, about this validation with user form.....

LMF · Apr 9th, 2002, 10:52 AM

I got a list of data, i used validation rules on them. I would like to use a form to add or edit data. But the thing is valiation was ignored if i use user form.

how can i overcome this problem, any1?

if i use dialog, will it help???

pls let me know

LMF · Apr 9th, 2002, 12:01 PM

pls help

Russell Hauf · Apr 9th, 2002, 12:07 PM

First off, I'd like to caution you against replying to your own message just to get it to the top. I know that some (including myself most of the time) will ignore people who do this. People on this board actually want to help, and will, if you give them a chance. Sometimes I answer posts that are a day or two old. Please be patient.

That said, just do your validation through VBA. Something like this:

If Len(TextBox1.Text) > 4 Then
MsgBox "Invalid Entry"
Exit Sub
End If

-rh

SofiaB · Mar 11th, 2006, 11:36 AM

in response to your code for the validation in the user form, i was wondering if you or anyone else would know if i am able to set the value of the length between a certain amount and if i am just restricted to text? could i also validate it so that the text box only contains numbers and not letters? thanks

Norie · Mar 11th, 2006, 11:40 AM

Sofia

Could you start a new thread?

I know Russell said he responded to old posts, but he meant posts a few
days old, not a few years.

By the way what you are asking is perfectly possible. Can you give more
details, preferably in a new thread?

Mar 11th, 2006, 11:40 AM	#5
Norie Board Regular Join Date: Apr 2004 Location: Yaren Posts: 58,375	Sofia Could you start a new thread? I know Russell said he responded to old posts, but he meant posts a few days old, not a few years. By the way what you are asking is perfectly possible. Can you give more details, preferably in a new thread? __________________ If posting code please use code tags.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 10:52 AM	#1
LMF Board Regular Join Date: Mar 2002 Posts: 73	I got a list of data, i used validation rules on them. I would like to use a form to add or edit data. But the thing is valiation was ignored if i use user form. how can i overcome this problem, any1? if i use dialog, will it help??? pls let me know

Apr 9th, 2002, 12:01 PM	#2
LMF Board Regular Join Date: Mar 2002 Posts: 73	pls help

Apr 9th, 2002, 12:07 PM	#3
Russell Hauf MrExcel MVP Join Date: Feb 2002 Location: Portland, OR USA Posts: 1,374	First off, I'd like to caution you against replying to your own message just to get it to the top. I know that some (including myself most of the time) will ignore people who do this. People on this board actually want to help, and will, if you give them a chance. Sometimes I answer posts that are a day or two old. Please be patient. That said, just do your validation through VBA. Something like this: If Len(TextBox1.Text) > 4 Then MsgBox "Invalid Entry" Exit Sub End If -rh

Mar 11th, 2006, 11:36 AM	#4
SofiaB New Member Join Date: Feb 2006 Posts: 14	in response to your code for the validation in the user form, i was wondering if you or anyone else would know if i am able to set the value of the length between a certain amount and if i am just restricted to text? could i also validate it so that the text box only contains numbers and not letters? thanks