Validation

[gatarossi]

Dear all,

How can I create a vba code to make a validation in a excel's cell?

This validation must be the datas from a field in one table in ms
access.

Thanks,

André.

 

[Jim Rech]

How can I create a vba code to make a validation in a excel's cell?

Recording a macro is always a good start.

If you're using the list feature of Data Validation the list must be in the
worksheet.

--
Jim
Dear all,

How can I create a vba code to make a validation in a excel's cell?

This validation must be the datas from a field in one table in ms
access.

Thanks,

André.