View Single Post
  #3   Report Post  
chopchop
 
Posts: n/a
Default

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.