Excel VBA Validation as a input function

[rvctips]

Hi,

I'm writting some code where with a CommandButton I'd like to input a value in a cell, but it must match a VALIDATION list.

I know I can write a loop and check if the input is ok (if the value is in the VALIDATION list), but I wonder if I can use straightly the VALIDATION function.


TIA,

 

[xlbo]

why not just set the cell up with validation beforehand ?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[rvctips]

Of course I've already set up the cell with the DATA-VALIDATION, but I want to have the user's control and so avoid writting in wrong cells.

So, my question is, under VBA is possible to use the VALIDATION's performances?

TIA

 

[xlbo]

I don't believe you can test a value against the validation criteria in VBA.....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question