Thread: Validation ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David W[_3_] David W[_3_] is offline
external usenet poster
 
Posts: 28
Default Validation ?

Got a Question
I have got 12 columns and 160 rows
I need to use an input box in each cell so you will know what cell your in,
know here's the trick
I know that I can use validation to do this by copying and doing a paste
special, BUT how do you get the contents of the message to grow by one
Example
if A1 had validation and it read
"Truck 1"
"Enter Gallons"
how could you get it to change to
"Truck 2"
"Enter Gallons" in A2 ;and so on
This one is a little tricky for me