I have a button that when pressed, I would like it to do the following
1. Save the Current Document
2. Pop up with a box (Form) requesting 5 fields of information to be
entered (Event Name, Date, Time, Person's Name, Distance)
3. At the bottom of this form there should be two buttons "Cancel" &
"Enter"
4. Cancel is Obvious, Enter should enter the entered fields into
specified cells in the spreadsheet then:
5. take the date field and reformat it into a format YYMMDD and save the
document as YYMMDD.xls
I am still a beginner with
VB so any samples would be highly appreciated
Thanking you all in advance for any assistance
Kind regards
Cathy