Address book

  • Thread starter Thread starter Bampah
  • Start date Start date
B

Bampah

I've created a very simple address book for my wife but would like to add a
box to the 1st column (Title) which would pop up to give her the option of
choosing :- Mr. Mrs. Miss etc.
Is this possible by just using my Excel from Office 2000 or do I need VB?
If it can be done, could you kindly point me in the right direction
TIA
 
I was hoping to set up a pop up box that would allow her to click on of the
options rather than to validate what she has entered.
 
Bampah, I think Earl was talking about using data validation so you could
pick which one you want, select column A then data, validation, allow, list
and under source enter your list like Mr.,Mrs.,Miss, Ms. then when you
select a cell it will have a drop down box to pick from

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Yes, Thanks Earl for your instruction which was perfect and also to Paul for
pointing out how thick I was being.
She's gonna think I'm a genius and excuse me from bathroom re-decoration
duties for another day.
Rob
 
Back
Top