It's a sample code for messagebox function in vba for excel spreadsheet
Sub diplaymessageBox()
Dim stranswer As VbMsgBoxResult
stranswer = MsgBox("Would you like to colour the cell?", vbQuestion + vbYesNo, "Select Option")
If stranswer = vbYes Then
Selection.Interior.ColorIndex = 8
End If
End Sub
Sub diplaymessageBox()
Dim stranswer As VbMsgBoxResult
stranswer = MsgBox("Would you like to colour the cell?", vbQuestion + vbYesNo, "Select Option")
If stranswer = vbYes Then
Selection.Interior.ColorIndex = 8
End If
End Sub
No comments:
Post a Comment