From the course: Excel VBA: Managing Files and Data
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Add graphics to a UserForm - Microsoft Excel Tutorial
From the course: Excel VBA: Managing Files and Data
Add graphics to a UserForm
- When you create a user form, you can add controls such as text boxes and labels to help your users enter data accurately. You can also add graphics. In this movie, I will show you how to add graphics to user form, both to make the user form more visually appealing and to add information. The sample file I work with is called 0606 graphic, and you can find it in the chapter six folder of the exercise files collection. I'm not going to work with the data in the worksheet at all. So I'll press alt F11 to move to the visual basic editor. And here you'll see that I have a user form already created and ready for editing. To add a graphic, or image, to this user form, I need to go over to the toolbox which is displayed here. If the toolbox doesn't appear, when you click the title bar of the user form, for example, if it were hidden accidentally, you can go up to the menu bar and click the toolbox button and the tool…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
(Locked)
Create a UserForm2m 38s
-
(Locked)
Add a TextBox to a UserForm3m 31s
-
(Locked)
Add a ListBox to a UserForm4m 52s
-
(Locked)
Add a ComboBox to a UserForm4m 55s
-
(Locked)
Add an option button to a UserForm3m 55s
-
(Locked)
Add graphics to a UserForm4m 28s
-
(Locked)
Add a SpinButton to a UserForm4m 16s
-
Create a multipage or multitab UserForm3m 50s
-
(Locked)
Write UserForm data to a worksheet7m 39s
-
(Locked)
Run a UserForm4m 8s
-
(Locked)
-
-