How do i validate input boxes when they have been created?

Sami · Mar 10th, 2002, 02:44 AM

I created the input boxes and they work. But i need to validate some of them. when i use data, validation, for a cell or a column it works but only when the data is entered manually. How do i validate the input boxes?
Thank u.

Dave Hawley · Mar 10th, 2002, 02:49 AM

Hi Sami

What are you refering to as "input boxes" and what do you want to validate them against.

If you are talking about ComboBoxes are they from the "Forms" toolbox or the "Control Toolbox" and are they on Worksheets or UserForms.

Sami · Mar 10th, 2002, 02:59 AM

hey, ive got a macro to input a new product in the system. The product ID in coulumn C has to be validated by text length to = to 4 characters. Also the Price in column D has to be validated for currency (if thats possible in £)
Thanks.

Sami · Mar 11th, 2002, 10:36 AM

...

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

Mar 10th, 2002, 02:44 AM	#1
Sami Board Regular Join Date: Mar 2002 Posts: 122	I created the input boxes and they work. But i need to validate some of them. when i use data, validation, for a cell or a column it works but only when the data is entered manually. How do i validate the input boxes? Thank u.

Mar 10th, 2002, 02:49 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Sami What are you refering to as "input boxes" and what do you want to validate them against. If you are talking about ComboBoxes are they from the "Forms" toolbox or the "Control Toolbox" and are they on Worksheets or UserForms.

Mar 10th, 2002, 02:59 AM	#3
Sami Board Regular Join Date: Mar 2002 Posts: 122	hey, ive got a macro to input a new product in the system. The product ID in coulumn C has to be validated by text length to = to 4 characters. Also the Price in column D has to be validated for currency (if thats possible in £) Thanks.

Mar 11th, 2002, 10:36 AM	#4
Sami Board Regular Join Date: Mar 2002 Posts: 122	...