ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Pull Down menu's (https://www.excelbanter.com/excel-worksheet-functions/49276-pull-down-menus.html)

Robin

Pull Down menu's
 
is it possible to create a pull down menu in excel? And if so, how do I do
it? Thanks!

Paul B

Robin, see if this will do what you want

http://www.contextures.com/xlDataVal01.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Robin" wrote in message
...
is it possible to create a pull down menu in excel? And if so, how do I do
it? Thanks!




Bob Phillips

See http://www.contextures.com/xlDataVal01.html

--
HTH

Bob Phillips

"Robin" wrote in message
...
is it possible to create a pull down menu in excel? And if so, how do I do
it? Thanks!




Max

Try Debra's nice coverage on data validation at her:
http://www.contextures.com/xlDataVal01.html

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Robin" wrote in message
...
is it possible to create a pull down menu in excel? And if so, how do I do
it? Thanks!




Max

Durn it, beaten to the "Pull Down menu" draw by 2 faster guns ! <g
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--



Bob Phillips

Ah, we are from the west, and they always draw faster in the west <g

--
HTH

Bob Phillips

"Max" wrote in message
...
Durn it, beaten to the "Pull Down menu" draw by 2 faster guns ! <g
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--





Max

ROTFL ! <g
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--



Robin

Thanks so much! Once I finally calmed down and read the instructions slowly I
managed to get it. Now EVERYTHING is going to have a pull down menu! Love it.

"Paul B" wrote:

Robin, see if this will do what you want

http://www.contextures.com/xlDataVal01.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Robin" wrote in message
...
is it possible to create a pull down menu in excel? And if so, how do I do
it? Thanks!






All times are GMT +1. The time now is 02:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com