Hello,
I am working on a project which users have a choice to choose from, however
I only want them to be able to choose one of the options provided. Is there a
way to do this? i was thinking of having the user click on the cell where the
option is and make that their choice in order to prevent error in typing if
that was an option.
For example:
COLUMN:
A B C D
E

Product Color Source Beam Spread
LNR Linear CW Cool White ASM 10°x90° Reflector
NW Neutral White MFL Medium Lens
RGB RGB NFL Narrow Lens
WW Warm White WFL Wide Lens


lnr CW asm mfl

Lets say that the user clicks on "CW" cell on column C, i want to send their
choice to another cell (like on the bottom CW on column C) to show their
choice they have made. This will prevent them from making a wrong choice or
trying to type something else when the choice is not give, this will also
prevent mistakes. of course this will be implemented on all of the columns
shown above and them some.

Please let me know if i can help you in understanding my problem. I hope am
making some sence here.
Thanks

TG

I usually use ListBox with the click event tied to the selection. As soon as
they click the selection the click event executes and does something with the
selected vaue. I normally set mine up on a userform so I can close it once
the selections are made.
Of course the number and complexity of choices would have bearing on how I
set the controls up.

"TG" wrote:

Hello,
I am working on a project which users have a choice to choose from, however
I only want them to be able to choose one of the options provided. Is there a
way to do this? i was thinking of having the user click on the cell where the
option is and make that their choice in order to prevent error in typing if
that was an option.
For example:
COLUMN:
A B C D
E

Product Color Source Beam Spread
LNR Linear CW Cool White ASM 10°x90° Reflector
NW Neutral White MFL Medium Lens
RGB RGB NFL Narrow Lens
WW Warm White WFL Wide Lens


lnr CW asm mfl

Lets say that the user clicks on "CW" cell on column C, i want to send their
choice to another cell (like on the bottom CW on column C) to show their
choice they have made. This will prevent them from making a wrong choice or
trying to type something else when the choice is not give, this will also
prevent mistakes. of course this will be implemented on all of the columns
shown above and them some.

Please let me know if i can help you in understanding my problem. I hope am
making some sence here.
Thanks

TG