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

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

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

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