save Y/N?

[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

 

[Haldun Alay]

If MsgBox("Save", vbYesNo, "Application Name") = vbYes Then
'Saving Process
Else
'return
End If


Haldun

 

[B. Wassen]

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

 

[Harald Staff]

Hi Ben

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