Date Issue

[chimp]

Could someone please help me.

I have attached my problem,

on the click of a button, called "Date Box" i have a userform appear.

i then have a textbox and a button.

I would like the text box to be autopopulated with today's date, an
the button to open a calandar so that this date can be changed i
requested.

my coding is very poor, so thats why i am asking here.....

Any help would be appreciated.

Cheers

And

+----------------------------------------------------------------
| Attachment filename: date issue.zip
|Download attachment: http://www.excelforum.com/attachment.php?postid=360425
+----------------------------------------------------------------

 

[Andy Brown]

my coding is very poor

Mine's close to non-existent (NB - there is a programming group).

I vaguely remember from a Chip Pearson response that you can use something
like

Private Sub UserForm_Initialize()
TextBox1.Value = Date
End Sub

in the form's module.

As far as the pop-up calendar goes, not sure what to advise. If you
rightclick the Control ToolBox, you should be able to access a Calendar
control via Additional Controls. But it would have to sit on the form in the
first place ...

HTH,
Andy