I always thought the ControlSource property of a UserForm control was updated on each Change event the control initiates, e.g. on each character change in a textbox, but I'm finding that the worksheet ControlSource is not updating until after the user exists the control. Is this the way UserForm controls are supposed to work?
Posts by phillfri
-
-
Re: Add a calendar to right click
I've been working on a calendar.xla that does a right-click popup.
I'm using the office 2003 calendar control. One might have to
replace the calendar control itself with one's own version.
I think this code will work on Excel versions 2000 and up.
Haven't done a lot of testing yet, but it seems to work pretty
good.When Excel is opened, Calendar is turned off.
Right click on cell and select "Turn Calendar On"
Now every cell that contains a date or is formatted as a date
will pop up the Calendar.
While the Calendar is on, there is an additional right click menu
option to pop up the Calendar when the selected cell is a non-date
format. That option will disappear when the Calendar is turned off
again.Lifted some of this code off the internet. Gave references where
I have done so. Hope this is useful for someone.Comments/fixes welcome :>)