Help with VBA Input Validation
Hi all,
I'm trying to get program a cell's input validation through vba.
Specifically, I want .InputMessage to equal a variable, so I need
something like this:
dim FOO as string
foo = "Yo"
With Selection.Validation
....
..InputMessage = FOO
....
....
End with
This code does not work. Any ideas? Thanks in advance...
Jim
|