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

LMF

Board Regular
Joined
Mar 16, 2002
Messages
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
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
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
 
Upvote 0
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
 
Upvote 0
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?
 
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,194
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top