Help with drop down selection list box

  • Thread starter Thread starter joecrabtree
  • Start date Start date
J

joecrabtree

To all,

I have a set of part numbers:

FX1999
FX2000
FCG344
FHJ7867

I want to be able to have a drop down box or list type of thing that
allows the user to select one of these parts. I then want the part
number to be shown in cell C2 of sheet1. I would prefer an answer that
uses a Macro as opposed to defining names/lists etc, and would like the
box to be placed where I choose it on the spreadsheet. i.e. not linked
to a cell like the data validation-lists approach. Is this possible? I
was thinking of using a combo box or list box.

Thanks for your help in advance,

Regards

Joseph Crabtree
 
Yes.

Use a ComboBox from the Control Toolbox Menu. Place your part numbers in a
range of cells. Example:
In Z1 enter FX1999 and in Z2, FX2000, etc.

Then, after you have drawn your ComboBox, right-click and select properties.
Set the ListFillRange to Z1:Z4. You can adjust that as necessary if there
are more than 4 part numbers. Then set the LinkedCell to Sheet1!C2

HTH,
Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Plot graph depending on drop down box selection 1
Drop Down List Showing Two Cells Info 1
EXCEL DROP DOWN 2
Drop Down List Format 2
Drop Down Box 7
AutoComplete Entry in Text Box or Drop Down List 6
using a conditional formula from a drop down list and If Statement 8
How to dynamically change the list in drop down list based on thevalue of another cell? 1

Back
Top