Macros help

D

dawaves

Hello,

Is there a way to put a macros into drop down validation list for a
user to select? Or better yet, anytime a cell is touched, a macros
launches? I have a pop up calendar macros that I want the user to see
everytime a cell is clicked on, that way, a user can select a date
from the pop up calendar and the cell automatically populates w/ that
correct date.

Any thoughts?

thanks!
 
´

´¯`·.. >

your likely referring to
the "calendar control" object
via menu > insert > object.

along with the calendar control
you should also ensure you are able
to view the "control toolbox" toolbar.

then you need to access the properties
pages for the control and assign the
cells to place the date selection...

there is a bit more to programming
with the control, but the above will
get you started....

- db
 
Top