You will need to make sure that you change the textbox name & destination cell
You might be interested in thisActiveCell.Value=Format(CDate(Me.TextBox1.Value,"short date"))
You will need to make sure that you change the textbox name & destination cell
You might be interested in thisActiveCell.Value=Format(CDate(Me.TextBox1.Value,"short date"))
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks