irresistible007
Board Regular
- Joined
- Nov 24, 2005
- Messages
- 173
okie i have a calendar control on my sheet which is only visible when a user click a combo drop down button... and gets invisble again when user selects a date (selected date is then passed to that combo)...
The little prob with it is that while calendar is visible if the user clicks on sheet the calendar doesn't just gets invisible which i want it to...
What are the suggestions?... what i have figured out yet... is that may be the best event to trigger for this purpose is combodate_DropButtonClick cuz the calendar is only visible at this point in time...
So..
I think it can be done by just putting a couple of lines before end Sub...but what it has to be...?
Maybe something like a If-Then condition to check if the Name Box (Excel's own control.. on left of formula bar) isn't blank cuz a positive thing is that when a control on sheet is selected the name box gets empty...
what do you suggest
The little prob with it is that while calendar is visible if the user clicks on sheet the calendar doesn't just gets invisible which i want it to...
What are the suggestions?... what i have figured out yet... is that may be the best event to trigger for this purpose is combodate_DropButtonClick cuz the calendar is only visible at this point in time...
So..
Code:
Private Sub combodate_DropButtonClick()
Calendar1.Visible = True
End Sub
I think it can be done by just putting a couple of lines before end Sub...but what it has to be...?
Maybe something like a If-Then condition to check if the Name Box (Excel's own control.. on left of formula bar) isn't blank cuz a positive thing is that when a control on sheet is selected the name box gets empty...
what do you suggest