Validation within userforms 1

[BlueMonkey]

Can someone recommend a best practice for validating the entries a user makes on a user form. The form I'm creating will contain dates and values.

Is there a function similar to the worksheet function IsNumber()

Thanks in advance

B.M.

 

[SkipVought]

Hi,

Have you looked at VB HELP for the Is... Functions?

Skip,
[sub]
[red]Be Advised![/red] A Last Will and Testament is...
A Dead Giveaway! [/sub]

 

[BlueMonkey]

From what I can make out the IsX doesn't work within VB

B.M.

 

[SkipVought]

IsNumeric Function


Returns a Boolean value indicating whether an expression can be evaluated as a number.

Syntax

IsNumeric(expression)

The required expression argument is a Variant containing a numeric expression or string expression.

Remarks

IsNumeric returns True if the entire expression is recognized as a number; otherwise, it returns False.

IsNumeric returns False if expression is a date expression.

Skip,
[sub]
[red]Be Advised![/red] A Last Will and Testament is...
A Dead Giveaway! [/sub]

 

[BlueMonkey]

Thanks for that Skip,

I double checked the VB help and found some references, however the hlp file required hasn't been installed on my system (and there's no chance of it being installed soon).

Do you know of a way of checking for a valid date?

Thanks very much



B.M.

 

[SkipVought]

IsDate function.

Also

http://www.microsoft.com

has LOTS of HELP stuff for VB/VBA.

Skip,
[sub]
[red]Be Advised![/red] A Last Will and Testament is...
A Dead Giveaway! [/sub]

 

[BlueMonkey]

Strewth - thanks a bunch Skip - I promise you I tried that before posting.

Thanks again

BM

B.M.

 

[PHV]

Have a look here:

http://msdn.microsoft.com/library/en-us/vbaof11/html/Welcome_HV01132015.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PHV]

OOps, wrong URL:

http://msdn.microsoft.com/library/en-us/vbaxl11/html/Welcome_HV01134775.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[BlueMonkey]

Thanks for your answers everyone. I now have the system working.

B.M.