[et_pb_section bb_built="1" next_background_color="#000000"][et_pb_row][et_pb_column type="4_4"][et_pb_text]
UserForm Basics #1
Here, you'll learn to make a UserForm, add a button, and make clicking on that button hide the UserForm!
Make a UserForm:
- Press Alt-F11 to bring up Visual Basics menu
- Click the drop down menu in the upper left hand and select UserForm:
- Press F4 to bring up the properties menu. Use this box to change the userform's name:
- Next, use the "Caption" field to change the UserForm's caption:
Add a Button:
- Using the Toolbox Controls, add a Command Button:
- In the UserForm area, single click to create a standard size button, or click and drag to create the button size you want:
- Click on the button's text to edit it's display text:
- Using the properties menu on the left, you can change the button's color, font, and other properties!
Hiding the UserForm when the button's pressed!
- Double-click on your Command Button (or whatever you've named it in the properties menu), to bring up the event script menu.
- Use the command ".Hide" as shown in the picture below. In this example, the UserForm's name was HideForm, thus the script line is "HideForm.Hide":
- [snippet id="50"]
Check out the video below for more details!
[frontpage_news widget="14410" name="You Might Also Like"]
[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section bb_built="1" _builder_version="3.0.105" prev_background_color="#000000" global_module="14500"][et_pb_row global_parent="14500" _builder_version="3.0.105"][et_pb_column type="4_4"][et_pb_text global_parent="14500" _builder_version="3.0.105"]
You Might Also Like
[/et_pb_text][et_pb_blog global_parent="14500" fullwidth="off" posts_number="6" include_categories="72,73,45,71,46,1,51" show_comments="on" offset_number="0" use_overlay="on" _builder_version="3.0.105" header_font="Playfair Display|700|||||||" header_font_size="20" header_line_height="1.4em" body_font="Poppins||||||||" body_font_size="16px" body_line_height="1.5em" meta_font="Poppins|600||on|||||" meta_font_size="12px" meta_text_color="#edbb5f" meta_letter_spacing="1px" meta_line_height="2em" pagination_font="Poppins|600||on|||||" pagination_font_size="16px" pagination_font_size_tablet="51" pagination_text_color="#edbb5f" pagination_letter_spacing="1px" pagination_line_height="2em" text_orientation="center" animation_style="flip" custom_css_content="display: none;"]
[/et_pb_blog][/et_pb_column][/et_pb_row][/et_pb_section]