![]() Type a prompt in the text box to the right of the Caption property in the Properties pane, such as “Yes, I’d like to subscribe.”ĭouble-click the check box to display the event procedure that will run when a user clicks the check box during execution of the userform. Click the "Insert" menu, and then click "Userform" to insert a new userform into the document.ĭrag a check box control from the Toolbox pane onto the userform. No message displays this time.Ĭreate a new Word document, then press "Alt-F11" to enter the VBA development environment. Your macro will run and display the message “You’ve subscribed.” Click the check box again to remove the check mark. This action activates the check box for data entry.Ĭlick the check box. Press "Alt-F11" to return to the Word document, then click the "Design" button in the Controls group of the Developer tab. If (Check box1.Value = True) Then MsgBox ("You've subscribed") End If These statements display a message if the user ticks the check box. Type the following VBA statements above the End Sub statement. ![]() Right-click the check box and click "View Code" to open the VBA development environment. ![]() For example, you could type “Yes, please sign me up for the newsletter.” Right-click on the check box and click "Properties."Ĭlick in the text box to the right of the Caption property in the Properties pane, then type the prompt you want the user to respond to by clicking the check box. Click the check box control to insert a check box into the current document. Click the "Developer" tab, then click the "Legacy Tools" button in the Controls group. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |