save Y/N?

  • Thread starter Thread starter B. Wassen
  • Start date Start date
B

B. Wassen

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
 
If MsgBox("Save", vbYesNo, "Application Name") = vbYes Then
'Saving Process
Else
'return
End If


Haldun
 
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
 
Hi Ben

Record a macro while saving and you have the proper syntax and parameters.
 
Back
Top