I'm using data valadation in Excel to make sure all information is entered
the same. I am not using drop down boxs (1) because of the font size (I know
there is a work aroung) and (2) because of the form. There are too many of
them and is difficult to use.

If the user types in the correct information, no problem it works great. If
the user types in the wrong information the error box pops up and tells them
to try again.

Is there a way to add one button to the worksheet that would create a popup
box with a list of valid entries and allow the user to select one to populate
the current cell. There is one column with many rows to be filled out but
all of them look to the same validation list.

Thanks.

Couldn't you just give a list of valid values in the DV?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jordan" wrote in message
...
I'm using data valadation in Excel to make sure all information is entered
the same. I am not using drop down boxs (1) because of the font size (I
know
there is a work aroung) and (2) because of the form. There are too many
of
them and is difficult to use.

If the user types in the correct information, no problem it works great.
If
the user types in the wrong information the error box pops up and tells
them
to try again.

Is there a way to add one button to the worksheet that would create a
popup
box with a list of valid entries and allow the user to select one to
populate
the current cell. There is one column with many rows to be filled out but
all of them look to the same validation list.

Thanks.

We did that but the writing is so small you cant read it.

"Bob Phillips" wrote:

Couldn't you just give a list of valid values in the DV?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jordan" wrote in message
...
I'm using data valadation in Excel to make sure all information is entered
the same. I am not using drop down boxs (1) because of the font size (I
know
there is a work aroung) and (2) because of the form. There are too many
of
them and is difficult to use.

If the user types in the correct information, no problem it works great.
If
the user types in the wrong information the error box pops up and tells
them
to try again.

Is there a way to add one button to the worksheet that would create a
popup
box with a list of valid entries and allow the user to select one to
populate
the current cell. There is one column with many rows to be filled out but
all of them look to the same validation list.

Thanks.