Restrict variable values between 0 and 1

[walduxas]

Hi,

I'd like to create new variable type, where the variable could be decimal and would be between 0 and 1 (like a probability). Is it possible to restrict variable between some lower and upper values?

[mehmetcik]

Why don't you use Data Validation for your cells.

Select your cell, Select the Data Tab and then Data Validation.

Set your validation to

Decimal

Min 0 Max 1

[6StringJazzer]

VBA does not support that as a built-in feature (the only language I know that does this is Ada). You can build a Class to do this. Here is the class, and a test:

Class Module Unit:

Please Login or Register  to view this content.

Test driver:

Please Login or Register  to view this content.

[walduxas]

Thank you 6StringJazzer. I was reading about defining variables in Class module, but couldn't find a working example. Your example is great. Thank you again.

[walduxas]

Why don't you use Data Validation for your cells.

Select your cell, Select the Data Tab and then Data Validation.

Set your validation to

Decimal

Min 0 Max 1

Thank's, but the question is about working with VBA, not working in Excel sheet. One of the user defined functions has the parameter, which should be limited to have values between 0 and 1.

[6StringJazzer]

One of the user defined functions has the parameter, which should be limited to have values between 0 and 1.

I gave a very general-purpose solution to your question. If you are specifically dealing with input to a UDF, that is an overly complicated solution. It may make more sense to simply check the value in the UDF rather than creating a class to deal with it:

Please Login or Register  to view this content.