| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
save Y/N?
From main menu I go to a database where I can change data. Before I return
to the main menu I would like to have a box wich asks "Save Y/N" If Y save (how?) Else Return Thanks, Ben |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
save Y/N?
If MsgBox("Save", vbYesNo, "Application Name") = vbYes Then
'Saving Process Else 'return End If Haldun "B. Wassen" , iletide şunu yazdı ... From main menu I go to a database where I can change data. Before I return to the main menu I would like to have a box wich asks "Save Y/N" If Y save (how?) Else Return Thanks, Ben |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
save Y/N?
Thanks,
the messagebox is working but how can I actually save the data? What comes after Then en between else and endif? Private Sub Hoofdmenu_Click() If MsgBox("Wilt u de wijzigingen opslaan?", vbYesNo, "Orderinvoer.xls") = vbYes Then Else End If End Sub "Haldun Alay" schreef in bericht ... If MsgBox("Save", vbYesNo, "Application Name") = vbYes Then 'Saving Process Else 'return End If Haldun "B. Wassen" , iletide şunu yazdı ... From main menu I go to a database where I can change data. Before I return to the main menu I would like to have a box wich asks "Save Y/N" If Y save (how?) Else Return Thanks, Ben |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
save Y/N?
Hi Ben
Record a macro while saving and you have the proper syntax and parameters. -- HTH. Best wishes Harald Excel MVP Followup to newsgroup only please "B. Wassen" skrev i melding ... Thanks, the messagebox is working but how can I actually save the data? What comes after Then en between else and endif? Private Sub Hoofdmenu_Click() If MsgBox("Wilt u de wijzigingen opslaan?", vbYesNo, "Orderinvoer.xls") = vbYes Then Else End If End Sub "Haldun Alay" schreef in bericht ... If MsgBox("Save", vbYesNo, "Application Name") = vbYes Then 'Saving Process Else 'return End If Haldun "B. Wassen" , iletide şunu yazdı ... From main menu I go to a database where I can change data. Before I return to the main menu I would like to have a box wich asks "Save Y/N" If Y save (how?) Else Return Thanks, Ben |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save, save as, page setup dimmed out in unprotected excel sheet? | Excel Discussion (Misc queries) | |||
| SAVE and SAVE AS options disappeared from the drop down FILE menu | Excel Discussion (Misc queries) | |||
| Command Button Save As Application.ExecuteExcel4Macro ("SAVE.AS?() | Excel Discussion (Misc queries) | |||
| how to get disk icon on save button of save as dialog like 2000 | Excel Discussion (Misc queries) | |||
| Save Excel file - prompts to save - no Volitile functions used | Excel Worksheet Functions | |||
Linear Mode
