Validating textboxes

Hi I have various text boxes. On initialisation one is blank no2 is "00" and no. 3 is "00"

I am looking for a way to validate that an entry has been made in each textbox and that it is numeric. And if no entry is made then populate msgbox stating to make entry and refocus on the textbox.

currently I have

Please Login or Register  to view this content.

im not sure if this is the correct way to validate or if this is simply a poor workaround Any thoughts much appreciated.

Hi there,

Take a look at the attached workbook and see if it does what you need. You'll obviously need to customise the text used in the labels on the form and the associated constant values used in the mbDataValidationIsOk function.

The VBA code uses some items which are definitely not "Beginner-Level" techniques, but are useful in providing a helpful user interface. Let me know if you need further information about the code.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Please Login or Register  to view this content.

Originally Posted by Greg M

Hi there,

Take a look at the attached workbook and see if it does what you need. You'll obviously need to customise the text used in the labels on the form and the associated constant values used in the mbDataValidationIsOk function.

The VBA code uses some items which are definitely not "Beginner-Level" techniques, but are useful in providing a helpful user interface. Let me know if you need further information about the code.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Many thanks for this Greg. Just the kind of thing I was after. As you say its perhaps not for beginner level but when I get to work tomorrow I will try and work through it all to see if I understand it all and will post back with any queries regarding the code.

Thanks again.

ps. can this validation approach also be applied to textboxes formatted as dates. For example if left empty or if date is in the future or not this year?

Hi again,

Thanks for your reply - it's nice to know that we're at least heading in the right direction

Regarding validation of Date values, it's certainly possible to expand the mbDataValidationIsOk function to accommodate checks for valid date values (use the IsDate function). You'll probably need to add a sDATE constant (with a value of "date ") so that you can generate a prompt message saying "You have not entered a date value for Data x".

Let me know if you need any further information.

Regards,

Greg M