Ask Your Question

How to generate and display a UserForm through VBScript?

asked 2021-06-04 11:00:00 +0000

bukephalos gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2022-08-06 05:00:00 +0000

ladyg gravatar image

Here is an example VBScript code to generate and display a UserForm:

' Create UserForm object
Set objForm = CreateObject("UserForm")

' Set UserForm properties
objForm.Caption = "My UserForm"
objForm.Height = 200
objForm.Width = 300

' Add Label control to the UserForm
Set objLabel = objForm.Controls.Add("Forms.Label.1", "lblMessage")
objLabel.Caption = "Hello, World!"
objLabel.Left = 50
objLabel.Top = 50

' Add Button control to the UserForm
Set objButton = objForm.Controls.Add("Forms.CommandButton.1", "btnOK")
objButton.Caption = "OK"
objButton.Left = 120
objButton.Top = 120
objButton.Default = True

' Show UserForm

This code will create a UserForm with a Label and a Button control. When the Button control is clicked, the UserForm will be closed.

Note: This code will only work in a Windows environment with Microsoft Office installed.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer

Question Tools


Asked: 2021-06-04 11:00:00 +0000

Seen: 10 times

Last updated: Aug 06 '22