software

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: www.excelforum.com/member.php...oamp;userid=30681
View this thread: www.excelforum.com/showthread...hreadid=503444Try Data Validation. Debra Dalglesih has details on her website at
www.contextures.com/xlDataVal01.html

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;bwallanquot; gt; wrote in
message ...
gt;
gt; I have a list of books I'm putting into a spreadsheet and I was
gt; wondering if it's possible, in a single cell, to list the book title
gt; and have a pull down menu where I can list the different chapters. But
gt; I want the pull down to go away when you click elsewhere.
gt;
gt; Would I need a macro for this? Or does Excel have an option I'm not
gt; finding? Or is this even possible?
gt;
gt; Thanks!
gt;
gt;
gt;
gt;
gt; --
gt; bwallan
gt; ------------------------------------------------------------------------
gt; bwallan's Profile:
www.excelforum.com/member.php...oamp;userid=30681
gt; View this thread: www.excelforum.com/showthread...hreadid=503444
gt;