Link to home
Start Free TrialLog in
Avatar of chestera
chestera

asked on

Monthly Scheduler

Hi EE
I am playing with developing a simple Monthly scheduler the text box for each day is
Width 3cm and Height is 2cm. Is there a way via vba when clicking on a text box it can expand to a given size. I would like  to click on a given day, box opens up then enter text for that day when exit the box shrinks back to original size. Any help appreciated

chestera
SOLUTION
Avatar of als315
als315
Flag of Russian Federation image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of chestera
chestera

ASKER

als315

Thank you for that just what I am looking for do you mind if I split the paints.

chestera
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
irogsinta

Many thanks for your input. I have split the points

chestera
als315

Again thank you for that sample dB

chestera
Here's a 30 day version.  To change the size of the large text box just change the constants largeWidthCm and largeHeightCm.
Irog/sinta

Thank you again

All the best
Alan
Last one.  This one includes labels and month traversal.
Calendar.accdb
IrongSinta

Excellent and thank you

Alan