View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim[_56_] Jim[_56_] is offline
external usenet poster
 
Posts: 1
Default 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