Thread: Cell validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Couchman[_4_] Robert Couchman[_4_] is offline
external usenet poster
 
Posts: 64
Default Cell validation

Hi all,

can somebody please help me?

i have a userform that asks uses to type in the results to
the questions, but for each answer there is 4 textboxes,
and in each one there can only be a number between 1 and 4
in them, also the number cannot be repeated in the
following textboxes.

if this is possible please could i also have the piece of
code that will select the textbox information if it is not
valid and then allow the user to retype the information.

thank you,

Robert Couchman