combo box for excel? 2

[kusazero]

is it posible for me to make a drop down menu for excel?

and if it is posible, i would like to have 2 boxes, the content of the 2nd box will be determined by the first object that i chose on box 1.

or i can only do that in access?

does anyone know any good siteson MS office? like for templates, tips, or tutorials?

thanks.

 

[carrr]

Check this out:

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

Also, use the advanced search function on this site to look for previous posts on Data Validation, that's what you're going to want.

"'Tis an ill wind that blows no minds." - Malaclypse the Younger

 

[YNOTU]

Make sure to read dynamic name ranges

http://www.beyondtechnology.com/geeks007.shtml

 

[kusazero]

thanks

 

[YNOTU]

Anytime

 

[kusazero]

carrr, that page is EXACTLY what i wanted thanks

decojute, err....the page you show me is little harder to understand for me, at the moment but thanks, helps me save money to go buy a book, or to help me gain more knowledge for the time being, so i know what book to choose.

 

[kusazero]

again, my excel skills is no more than having a certain cell multiplying another cell.

my next problem is, continue from the above scenerio, after i chose the item in box2, i would like, let say, cell A3, A4, A5 to display certain data about the item i selected in box2.

lets say, i selected "Peter" on box2, i would like A3 to display his "sex", A4 being "age", A5 is "height".

the thing is, i know what i want when i describe them, but won;t know what to look for, like "Data Validation", if i know i am looking for data validation at the irst place, it would be easier for all of us, ideas?

and again, thank you

 

[kusazero]

bump, and thanks for the help