Shane, thanks for the quick response. I used the data --validation command
to construct the drop down list; e.g., Jan, Feb, Mar etc. I have columns for
the days of the week (M,T,W etc) and a row for the date. I would like to auto
populate the date cell for Th with a 1, Fr a 2 etc, when Jan is chosen on the
drop down. I am quite VBA challenged, so any direction would be appreciated,
thx jb21

"Shane Devenshire" wrote:

Hi,

The simple answer is Yes. Provide the cells have formulas which respond to
the value populated in the pull down. (By the way what type of pull down are
you talking about - Data, Validation, List, or Combo box (Forms) or Combo box
(Control Toolbox)?

If you mean will it automatically fill in empty cells, the answer is only if
you write a VBA program to do so.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"jb21" wrote:

I am wondering if excel will change cell contents when different pull down
menu choices are populated, e.g., if I choose Jan 09 from a pull down menu, I
want to auto populate date cells 1-31 on correct day of the week (specific
cells)?