validation

canablitz

New Member
Joined
Mar 17, 2002
Messages
19
hi, i am having trouble with writing a project, i want a text box in a membership form, and i want people to enter a post code, and i want it to only allow the correct ammount of charachters to be entered, e.g ll68 abc, and if it is entered incorrectly then an error message would pop up. can anyone help me as this is really troubling me. any help would be much appreciated

BoB
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
On 2002-03-18 01:39, canablitz wrote:
hi, i am having trouble with writing a project, i want a text box in a membership form, and i want people to enter a post code, and i want it to only allow the correct ammount of charachters to be entered, e.g ll68 abc, and if it is entered incorrectly then an error message would pop up. can anyone help me as this is really troubling me. any help would be much appreciated

BoB

Hi Bob
The textbox has a property
Maxlength....set this to your max length.

To view the textboxs propetties
Just press F4 while in the VBE editor


HTH


Ivan
 
Upvote 0
hello

I have a password to allow users to enter, they sign up and choose passwords. But, i was waundering if its possible to make the computer actually recognise the user and remember their details, eg. address

thnks alot Craig
 
Upvote 0
On 2002-03-18 01:53, Craig AS wrote:
hello

I have a password to allow users to enter, they sign up and choose passwords. But, i was waundering if its possible to make the computer actually recognise the user and remember their details, eg. address

thnks alot Craig


Basically
Use a seperate sheet to record there details
Hide this sheet.
Use workbook open & a userform to get
the info and do a check against the data
you have in the hidden sheet.

There are a lot of ways to do this.....
have a go @ trying to do this.
If you get stuck then repost with your problem and I'm sure
someone will help


Ivan
 
Upvote 0

Forum statistics

Threads
1,213,544
Messages
6,114,249
Members
448,556
Latest member
peterhess2002

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