D
debartsa
Hi everybody,
I'm using Excel 97 with VBA to dynamically add a Validation object to
cell("A7").
My goal is to have an in-Cell dropdown list display when a user selects the
cell...
With ThisWorkbook.ActiveSheet.Range("A7").Validation
.Add Type:=xlValidateList, Formula1:="Red,Green,Blue"
End With
I get a Run-time error='1004' Application Defined or object-defined error?
Can I dynamically add a in-cell drop down list to a cell?
Thanks for any help!
Sam
I'm using Excel 97 with VBA to dynamically add a Validation object to
cell("A7").
My goal is to have an in-Cell dropdown list display when a user selects the
cell...
With ThisWorkbook.ActiveSheet.Range("A7").Validation
.Add Type:=xlValidateList, Formula1:="Red,Green,Blue"
End With
I get a Run-time error='1004' Application Defined or object-defined error?
Can I dynamically add a in-cell drop down list to a cell?
Thanks for any help!
Sam