Solved

Revealing a hidden pop up calendar in Excel VBA

Posted on 2008-10-31
10
1,005 Views
Last Modified: 2012-08-13
How do I unhide a calendar from a user form? I am trying to reveal a calendar after a combo box is selected using the  "Mouse Down" event.The calendar itslef has been inserted onto the user form. I have turned the visible properties of the calendar to "false" .The code in the"mouse down" event for the combo box is: Calendar1.Visible = True. After selecting the combo box nothing happens. Please help.
Private Sub ComboBox1_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
    
    Calendar1.Visible = True
    
  
End Sub

Open in new window

0
Comment
Question by:jezza12
  • 5
  • 3
  • 2
10 Comments
 
LVL 17

Expert Comment

by:ExcelGuide
ID: 22849188
could you try:
me.Calender1.Visible = True

or

UserForm1.Calender1.Visible = True
0
 

Author Comment

by:jezza12
ID: 22849575
Thank you for your response.
I tried both options but still get the same result - the calendar doesn't reveal itself.
0
 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
ID: 22849655
Hi jezza12,

It works fine for me. Can you confirm the MouseDown event is being called? You can use a MsgBox, like this....

    Private Sub ComboBox1_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)    
        Calendar1.Visible = True      
        MsgBox "Mouse Down"
    End Sub

Regards,

Wayne
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
LVL 17

Expert Comment

by:ExcelGuide
ID: 22849772
hi webtubbs,

I guess I start to understand this problem. Because I actually dont see anything as well BUT when I randomly click on the userform I start seeing the calendar partially...maybe this user has the same problem?

jezza, could you confirm?
0
 

Author Comment

by:jezza12
ID: 22854248
Hi Wetubbs and Psychotec,

Webtubbs, I tried your suggestion and the message box IS displayed on the mouse down event. So the actual event seems to be working.
In response to Psychotec, you seem to be experiencing exactly the same problem as me. No calendar is seen on the mouse down event. However, when I randomly click on the userform the calendar partially reveals itself.

Regards  Jezza
0
 
LVL 47

Accepted Solution

by:
Wayne Taylor (webtubbs) earned 50 total points
ID: 22855058
Jezza,

Try Repainting the form in the MouseDown event....

    Private Sub ComboBox1_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)    
        Calendar1.Visible = True      
        Me.Repaint
    End Sub

Wayne
0
 

Author Comment

by:jezza12
ID: 22855124
Wayne

Thank you - that seems to have done the trick. Just out of curiosity - is this a bug?

Regards Jezza
0
 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
ID: 22855158
Yes and No. There's generally no problem with the normal Forms control, but specialist controls, such as the Calendar, can sometimes have problems.

Wayne
0
 

Author Comment

by:jezza12
ID: 22855224
Thanks once again.
0
 

Author Closing Comment

by:jezza12
ID: 31512002
Thank you for your prompt assistance.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The purpose of this article is to demonstrate how we can use conditional statements using Python.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question