How to put a calader object on a form???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I put a calander object on my form to use as a pop up? Anybody with
help please
 
The link describe how to create a pop up calender on a worksheet. I need to
know how to create it on a "UserForm"
 
From a form module in the VBE, right-click on the Toolbox (if it is not
visible when the UserForm is active select View\Toolbox) and select
Additional Controls. This will bring up a list of controls that you can add
to your toolbox. Scroll down to Calendar Control xx.0 (where xx will be a
version number, mine is 11.0). This will place a new control icon on the
toolbox. Select this new icon and draw a calendar on the userform.

Hope that helps!
 
Thank you for the reply A, but I seem to have a problem that you may be able
to solve. When I am in VBE and right clik on the toolbox, it gives me an
option for "additional tools". However when I select it, all it does is make
the cursur turn into an HourGlass for a few seconds, but no additional tools.
I do have these additional tools on the Excel workbook tool bar, but not in
VBE. Where can I look for the little "Gremlin" please? Your help is much
valued.
JM
 
That is out of my league. I know how to use it, but not how to fix it when
its broken...guess that means I am not an expert (I already knew that, of
course).

Sorry I couldn't help more. I would suggest you post this as a new question
because posts over 1-2 days old rarely get answered.
 
In VBE go to Tools then additional controls
JohannM said:
Thank you for the reply A, but I seem to have a problem that you may be able
to solve. When I am in VBE and right clik on the toolbox, it gives me an
option for "additional tools". However when I select it, all it does is make
the cursur turn into an HourGlass for a few seconds, but no additional tools.
I do have these additional tools on the Excel workbook tool bar, but not in
VBE. Where can I look for the little "Gremlin" please? Your help is much
valued.
JM
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook issue 1
Can I set up individual calanders and combined on family calander? 1
Change calander in outlook today 1
Editor can't set appointments 1
DTPicker Calander Popup 5
Can a TextBox on a user form activate a popup calander for date se 2
outlook today (please help!!!!!!!!!!!!!!!!!!!!! 0
How to change add-in object from within worksheet module. 3

Back
Top