I have inserted a calender using: Insert/Object/Calendar Control 9
Any time I click on the date cell, it appears on the bottom and to the left
of the date cell. How can I locate it on the right side of the date cell?
Thanks for any comments.
Dori
I have inserted a calender using: Insert/Object/Calendar Control 9
Any time I click on the date cell, it appears on the bottom and to the left
of the date cell. How can I locate it on the right side of the date cell?
Thanks for any comments.
Dori
Hi,
On the Visual basic Toolbar, click the button for 'Design Mode'
then select the Calendar Control and move it using the mouse where you want
it.
I personally host controls like that in a userform that is only shown when
the user double-clicks on the cell, or selects the cell. Then when the user
chooses a date in the form, I hide the form and put the value of the calendar
control in the cell.
Another good alternative (if it is installed) is to use the date-Time Picker
control.
I hope that helps
Philip
"DORI" wrote:
> I have inserted a calender using: Insert/Object/Calendar Control 9
> Any time I click on the date cell, it appears on the bottom and to the left
> of the date cell. How can I locate it on the right side of the date cell?
> Thanks for any comments.
> Dori
Hi Philip,
I used the "Design Mode" and moved the calendar control but after entering
the date, when I wanted to enter the second date, it poped up over the
original location which blocks me from seeing other info adjacent to the date
cells. Is there a VBA to insert to make the calendar to pop up to the right
of date cell or permanently relocate it?
Thanks,
Dori
"Philip" wrote:
> Hi,
>
> On the Visual basic Toolbar, click the button for 'Design Mode'
>
> then select the Calendar Control and move it using the mouse where you want
> it.
>
> I personally host controls like that in a userform that is only shown when
> the user double-clicks on the cell, or selects the cell. Then when the user
> chooses a date in the form, I hide the form and put the value of the calendar
> control in the cell.
>
> Another good alternative (if it is installed) is to use the date-Time Picker
> control.
>
> I hope that helps
>
> Philip
>
> "DORI" wrote:
>
> > I have inserted a calender using: Insert/Object/Calendar Control 9
> > Any time I click on the date cell, it appears on the bottom and to the left
> > of the date cell. How can I locate it on the right side of the date cell?
> > Thanks for any comments.
> > Dori
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks