Can a TextBox on a user form activate a popup calander for date se

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

Guest

I would like a pop up calander to appear for a date selection when I activate
the "Date" field on my user form. What is the best way to do this please?
 
put a calendar object on your form called calSetDate and a command
button call cmdSetDate
when form is opened use the following commands

cmdSetDate.Visible = False
cmdSetDate.Enabled = False
calSetDate.Visible = False
calSetDate.Enabled = False
use a double click method on the date field and the following cobe
calSetDate.Visible = True
calSetDate.Enabled = True
cmdSetDate.Visible = true
cmdSetDate.Enabled = true
select a date and then click on the command button

If IsNull(calSetDate.Value) Then

Else
txtDate.SetFocus
txtDate.Text = calSetDate.Value
end if
lstEmpName.Visible = True
lstEmpName.Enabled = True
calSetDate.Visible = False
calSetDate.Enabled = False
cmdSetDate.Visible = False
cmdSetDate.Enabled = False
 
Thank you for the reply Rub. I have just one problem, I don't know how to put
a calander object on my form. Can you advise me please
 
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

Date Picker 1
DTPicker Calander Popup 5
Excel Calander code changes 2
How do I create a User form to input Data into an Ecel spreadsheet 2
calander control and copy command problem 5
How to put a calader object on a form??? 6
How do I add a drop down calander function to excel? 2
Popup calander 1

Back
Top