View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default change cell contents when pull down menu choices change

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)?