Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pop up box/form before save
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
save form | Excel Discussion (Misc queries) | |||
Button in Excel that will save the form? | Excel Worksheet Functions | |||
Save value on form | Excel Programming | |||
Save from form input | Excel Programming | |||
how to save the input of the controls in a form | Excel Programming |