B
bob.crimmins
I think this one will definitely take some imagination.
In an Excel VBA from, when you click on the DTPicker control it
displays a month calendar appears and you are able to select a date. I
need to figure out how to expand the calendar programatically, i.e.,
without having to click on it. Ideally, the control would have
included a "Expand" method but no such luck. The control does have an
hWnd property so perhaps there is a Win32 API approach that might
work??
Incidentally, using a slicker, third-party calendar control is not an
option because there will be no opportunity to install any new controls
on the user's machines.
Thanks in advance,
Bob
In an Excel VBA from, when you click on the DTPicker control it
displays a month calendar appears and you are able to select a date. I
need to figure out how to expand the calendar programatically, i.e.,
without having to click on it. Ideally, the control would have
included a "Expand" method but no such luck. The control does have an
hWnd property so perhaps there is a Win32 API approach that might
work??
Incidentally, using a slicker, third-party calendar control is not an
option because there will be no opportunity to install any new controls
on the user's machines.
Thanks in advance,
Bob