Are you planning to distribute your workbook? If your other users don't have
the same control installed you may have problems (I accidently did that,
used the calendar control that was installed with Access and then tried to
distribute my workbook to people who didn't have Access- ouch.). If this is
just for your own use, ignore this
To answer your other question, some of the more experienced folks might be
able to tell you if there is an "on_enter" event for a textbox. For my
application, I put a button and a label, so I (and the other users) could
click the button to change the date. It brought up a second userform, sized
exactly to the size of the calendar control. The selection of a date on the
calendar control populated the label on the main form, and cancelling the
calendar control without an entry was handled and returned a null value.
HTH
Keith
"Coza" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> OK,
> Installed MSAccess and i now have the Calendar Available.
> How can i get it to run when a Textbxo is Entered on a userform ?
>
> Corey....
> "NickHK" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Depends which calendar control, but the MS one is installed with Access I
>> believe.
>> Others available, including the DTPicker.
>>
>> NickHK
>>
>> "Coza" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> How can i make this available?
>>>
>>>
>>
>>
>
>