I'm creating a form in excel and have inserted a dropdown list. The form is
for beginner excel users to use. I want the user to choose one of the
numeric choices in the dropdown list and then that number will be added to
the cel. But, I want the user to see the definition of the number when
he/she chooses it. But I don't want the definition to be put into the cel.
Is there a way to do this?

different ways to do this:
first of all, remember you know (easy) the number of the choosen item.
But then you can do what you want with it no-one make you put this exact
value into a cell
so you can use any "select case" or "if then else" syntax to make your
action

In your case, I suppose a way could be formating your dropdownlist :
example

01 - first choice
...
12 - last choice

and then just take the 2 first characters from the choosen string
with left(choice$,2)
if you can make it this way it's very simple.

I guess I need a little more education how to create the if then else syntax
or the chosen string.

"abcd" wrote:

different ways to do this:
first of all, remember you know (easy) the number of the choosen item.
But then you can do what you want with it no-one make you put this exact
value into a cell
so you can use any "select case" or "if then else" syntax to make your
action

In your case, I suppose a way could be formating your dropdownlist :
example

01 - first choice
...
12 - last choice

and then just take the 2 first characters from the choosen string
with left(choice$,2)
if you can make it this way it's very simple.

ok, so you mean you need first to learn how to do this :
so maybe it's better to try this first without vba:

in A1 put "01 - first choice"
in A2 put LEFT(A1,2)

here it is, and i thing you do not need more.

so, if in A1 there's a dropdown list of choices (see this post if you
need more data

)

if you are making the list of choice in vba, I suppose you know how to
do this and you can use the same in left function (also available in vba
code)

Thank you. At this point I think I could have paid someone to create this
form as many hours as I have spent on it. I appreciate your patience.
thanks again

"abcd" wrote:

ok, so you mean you need first to learn how to do this :
so maybe it's better to try this first without vba:

in A1 put "01 - first choice"
in A2 put LEFT(A1,2)

here it is, and i thing you do not need more.

so, if in A1 there's a dropdown list of choices (see this post if you
need more data

)

if you are making the list of choice in vba, I suppose you know how to
do this and you can use the same in left function (also available in vba
code)

if you mean to give me money , it's ok for me ;)

Seriously, I've spent the last several hours trying to get this form created
and frankly I'm not even close. I'm sure there is someone that could do it
easily. Have a good day. I still don't have it figured out!

"abcd" wrote:

if you mean to give me money , it's ok for me ;)