I have a list of books I'm putting into a spreadsheet and I was
wondering if it's possible, in a single cell, to list the book title
and have a pull down menu where I can list the different chapters. But
I want the pull down to go away when you click elsewhere.

Would I need a macro for this? Or does Excel have an option I'm not
finding? Or is this even possible?

Thanks!

:)


--
bwallan
------------------------------------------------------------------------
bwallan's Profile: http://www.excelforum.com/member.php...o&userid=30681
View this thread: http://www.excelforum.com/showthread...hreadid=503444

Try Data Validation. Debra Dalglesih has details on her website at
http://www.contextures.com/xlDataVal01.html

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"bwallan" wrote in
message ...

I have a list of books I'm putting into a spreadsheet and I was
wondering if it's possible, in a single cell, to list the book title
and have a pull down menu where I can list the different chapters. But
I want the pull down to go away when you click elsewhere.

Would I need a macro for this? Or does Excel have an option I'm not
finding? Or is this even possible?

Thanks!

:)


--
bwallan
------------------------------------------------------------------------
bwallan's Profile:
http://www.excelforum.com/member.php...o&userid=30681
View this thread: http://www.excelforum.com/showthread...hreadid=503444