VBA Site contains VBA code to create macros in WORD EXCEL ACCESS OUTLOOK

 

Popup_msgbox

Sub Popup_msgbox()

Dim PoPMsgBox As Object

Set PoPMsgBox = CreateObject("WScript.Shell")

Dim PoPMessage As Integer

Dim Sec As Integer

Sec = 1

For i = 1 To 10

PoPMessage = PoPMsgBox.Popup(i, Sec, "Title", 0)

Next

End Sub

 

MsgBox "if yes... else no ..." construction

Sub MessageBox()

answer = MsgBox("Choose:" & vbNewLine & "YES for action #1" & vbNewLine & "NO for action #2", vbYesNo)

If answer = vbYes Then

MsgBox "You chose YES"

Else

MsgBox "You chose NO"

End If

 

InputBox

Sub Input?Box()

Data = InputBox("Input number", "Title")

MsgBox "You entered number: " & data

End Sub



Dodaj komentarz






Dodaj

© 2013-2024 PRV.pl
Strona została stworzona kreatorem stron w serwisie PRV.pl