Is it possible to have a data Validation List in a WorkSheet to be in an
Input Box, to make a choice from ?
If so How ?

Regards

Corey McConnell

Hi Corey,

You intentions are unclear as a data validation list itself offers a
selection choice.

Perhaps you could expand on your requirements?


---
Regards,
Norman


"Corey" wrote in message
...
Is it possible to have a data Validation List in a WorkSheet to be in an
Input Box, to make a choice from ?
If so How ?

Regards

Corey McConnell

As with a LIST of choices from a cell using Data Validation.
I want to know if it is possible to instead of having a single input box to
place a value into,
I would like to have a LIST of options to choice from in the Input Box.


EG.
If a Input Box asks for : "Enter a Customer name ?"
Rather than having the chance of a typing error when typing in say "KMart" a
List would display Previously eneterd values,
and a slection would/could be made from these if it was used before.

Regards

Corey....


"Norman Jones" wrote in message
...
Hi Corey,

You intentions are unclear as a data validation list itself offers a
selection choice.

Perhaps you could expand on your requirements?


---
Regards,
Norman


"Corey" wrote in message
...
Is it possible to have a data Validation List in a WorkSheet to be in an
Input Box, to make a choice from ?
If so How ?

Regards

Corey McConnell

Hi Corey,

Try using a Userform with a ComboBox control.



---
Regards,
Norman


"Corey" wrote in message
...
As with a LIST of choices from a cell using Data Validation.
I want to know if it is possible to instead of having a single input box
to place a value into,
I would like to have a LIST of options to choice from in the Input Box.


EG.
If a Input Box asks for : "Enter a Customer name ?"
Rather than having the chance of a typing error when typing in say "KMart"
a List would display Previously eneterd values,
and a slection would/could be made from these if it was used before.

Regards

Corey....


"Norman Jones" wrote in message
...
Hi Corey,

You intentions are unclear as a data validation list itself offers a
selection choice.

Perhaps you could expand on your requirements?


---
Regards,
Norman


"Corey" wrote in message
...
Is it possible to have a data Validation List in a WorkSheet to be in an
Input Box, to make a choice from ?
If so How ?

Regards

Corey McConnell