Check out this site of Debra Dalgleish, where you can find examples of what
you're looking to do:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"mishee" wrote in message
...
...when you choose from a drop down list, how do you get other cells to
update off of your choice?

thank you