HI,
If you form shows in the workbook open then have the textbox load at the time the form shows.
![]()
With Userform1 .txtDateBox.Text = Format(Now(), "dd/mm/yy") end with
HI,
If you form shows in the workbook open then have the textbox load at the time the form shows.
![]()
With Userform1 .txtDateBox.Text = Format(Now(), "dd/mm/yy") end with
Last edited by Charles; 06-09-2011 at 01:50 PM. Reason: had time to post before taking off
Charles
There are other ways to do this, this is but 1 !
Be Sure you thank those who helped.
IF YOU'RE SATISFIED BY ANY MEMBERS RESPONSE TO YOUR ISSUE PLEASE USE THE STAR ICON AT THE BOTTOM LEFT OF THE POST UNDER THEIR NAME.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks