Here are some examples for how to add or display message box in vba
Sub messgaebox1()
' message you want to display , type of message box , title of message box
MsgBox "12 Rows Deleted", vbInformation, "Task"
End Sub
Sub messgaebox2()
Dim swa As String
swa = MsgBox("Do You Want to Continue", vbQuestion + vbYesNo, "Choose Your Option")
If swa = vbYes Then
MsgBox "You selected Yes", vbInformation, "Answer"
Else
MsgBox "You selected No", vbInformation, "Answer"
End If
End Sub
Sub messgaebox3()
Dim swa As String
swa = MsgBox("Do You Want to Continue", vbQuestion + vbOKCancel, "Choose Your Option")
If swa = vbOK Then
MsgBox "You selected ok", vbInformation, "Answer"
Else
Exit Sub
End If
End Sub
Subscribe to:
Post Comments (Atom)
Import data from SQL
Macro to import data from SQL using ADO connection string: Sub Import_data_from_SQL() ' Tools -> References -> Microsoft Active...
-
If you have added the shape in the sheet and now you want to change it color , text , font size ,etc using VBA. Snapshot below Code- Su...
-
If you want to add a new pop up button on mouse right click menu and as soon as you click on it . It shows you multiple buttons with macro a...
No comments:
Post a Comment