VBA Coding for Data Validation

[trishcollins]

I am writing VBA code for validation and want to convert the following three formulas (normally typed into the validation source dialog box) for use in VBA code. As they are, they will not work. Can anyone help?

"=OFFSET(Prov_Start,MATCH(A3,Prov_Column,0)-1,5,COUNTIF(Prov_Column,A3),1)"
"=IF(D3="""",Category_List,INDEX(Category_Column,MATCH(D3,Equipment_Column,0))) "
"=OFFSET(Category_Start,MATCH(C3,Category_Column,0)-1,8,COUNTIF(Category_Column,C3),1)"

I will be setting them up as strings, then using the string in the validation code as follows:

This is the example for the first validation. I get an error on the "Formula1:=strRefRange" line, as I am sure the syntax is incorrect in the string.

Please Login or Register  to view this content.

[venkat1926]

did you try "RECORDING" the macro taking the steps and try to edit it.