×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Drop down menu?

Drop down menu?

Drop down menu?

(OP)
Sorry in advance for this probably easy question, but could anyone let me in on the secret of linking the contents of a drop down menu with the input of a fomula. IE. I know how to create a drop down menu, but I can't figure out how to lik the information in the menu to a cell/formula. For example: if the menu has a 1 selected, I want the formula to use this number, or if the menue has a 5 or 10, or any number with the menu selected, use this number!

Thanks in advance,
Valintine.

RE: Drop down menu?

I assume you used the "listbox" from the Control Toolbox in Excel. When you are in the "design mode" and right click on the listbox, you can select "properties". One of the properties is "LinkedCell". The selected item will be entered into this linked cell.

RE: Drop down menu?

(OP)
Oh OK, and after I do this I assume I reference the formula to the new cell that the menu is linked to?

Thanks!
Valintine.

RE: Drop down menu?

Correct. I normally link to a cell that is hidden behind the listbox, but this is not required.

RE: Drop down menu?

(OP)
Thanks alot Guidoo, I have another question to bother you with.

Can I setup the list box so that when a perticular cell has a certian number in it the list box gives me a certian range of options?

Forinstance, if a cell has a number 1 in it, the list box has say a list of cars in it. Or if the cell has a number 2 in it, the list box has a list of countrys etc.?

Any help would again be appriciated!

Valintine.

RE: Drop down menu?

Valentine,

Yes, that is possible. I will use an example:

For your listbox, you have a ListFillRange selected of say A1:A5.
In cell A1, you have the formula:
=IF($B$1=1,C1,D1)
In cell C1 you have "Ford"
In cell D1 you have "France"

In cell A2, you have the formula:
=IF($B$1=1,C2,D2)
In cell C2 you have "Volkswagen"
In cell D2 you have "Germany"

and similar for cells A3..A5

So when you have 1 entered in cell B1, you will get the cars in your listbox. For every other value in B1, you will get the countries in your listbox.

If you only want to have the countries when you have 2 entered in B1, enter following formula in A1 etc.
=IF($B$1=1,C1,IF($B$1=2,D1,"")). The listbox will now be empty if you enter a value other than 1 or 2 in cell B1.

RE: Drop down menu?

(OP)
Thank you again!

Very useful!
Cheers

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources