View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ben ben is offline
external usenet poster
 
Posts: 232
Default How do you create a calendar drop down in excel?

What do You mean exactly by a "Calander 'drop down box'". If you want to have
a calander pop up when a user clicks in a certain cell, you can create a
userform with a calander control on it. The calander control is an add-on
control however and will only exist on systems that have it installed. If
it's not installed, the function will error out. To have it pop up for
clicking certain cells, add an event to the selection change in the worksheet
module.
--
When you lose your mind, you free your life.


"Calendar drop down box in excel" wrote:

Does anyone know how you would create a calendar drop down box in excel?