Drop-down menus

M

Matt

I have been trying all morning to work out how tomake a
drop-down menu in a cell. Is it possible in Windows 98?
 
J

JMay

Yes, While in desired cell go to the menu, click on Data, Validation, Select
List from Allow box and in source box type in either:
Choice1,Choice2,Choice3 <<< For more non-changeable type entry-types
or
First before doing the above type in another area of your worksheet say
In K1 Choice1
In K2 Choice2
In K3 Choice3
In this case, in the source box type in =K1:K3
That should work for you..
Good Luck
 
M

Matt

Cheers J, thats worked, but has led me to my next problem.
If I put in a formula such as =IF(B13="Internal",C13,IF
(B13="External",D13,"")), how do I get my result to be the
drop down menus that I have put in C13 and D13? B13 is
also a drop down menu. What I ideally want is a first
drop down menu which will bring up a second drop down menu
depending upon what you picked in the first.
 

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

Auto fill Cells with text 2
Formatted cell column in drop down list 1
Restrict Choice in Shared WB (drop down alternative)? 0
Modifying Data in Drop Down Menu 2
Date Range Drop Down Menu 1
Default value in Drop down menu and automatic selections 3
Vlookups not working 2
Drop Down Menu AutoPopulate Contact Info? 2

Top