What is the syntax to load an image?

<image control name>.Picture = LoadPicture(<file path in string form>)
profileImg.Picture = LoadPicture("C:\Users\john\Documents\johnsface.jpg")

strPath = "C:\Users\bob\Pictures\Landscapes\picoftrees.jpg"
image1.Picture = LoadPicture(strPath)


Helpful Tips

  • To add an Image Control, directly drag an Image from the Toolbox menu onto your UserForm.
  • To change the name of an Image Control, go to the Properties window in the UserForm Editor and change the name under field “(Name)”.
  • If you do not see your Toolbox or Properties window, go to the top under View and toggle your visibility settings
  • To find the string filepath for your image, you may find this article helpful: How do I find the filepath for a folder?

Tips for User Interface Design [updating]

  1. Use simple dialog understandable by your target user (ie) no jargon
  2. Rely little on user memory (ex) lesser steps for user to memorize/follow
  3. Output meaningful error messages (ex) when error happens, tell them using normal english vs something like “error code 1035”
  4. Avoid limitless choices (ex) Give them a limit of choices as often as possible, vs an open text field that could produce all sorts of data mismatch errors
  5. Always have an exit (ie) never put user in a place where they cannot go back or get out
  6. Exploit consistency (ie) familiarity equates speedy learning
  7. Provide continuous feedback (ex) instead of just a loading bar, have a label underneath that tells the user what step the computer is on
  8. Purpose (not beauty) dictates design (ex) look at how ugly but popular sites like Reddit, Craigslist are

What is the syntax to open a userform?

Put the code below in a separate module from that of the userform. A common choice for users is the proceduce of Workbook_Open() under module ThisWorkbook.

Private Sub Workbook_Open()
    <user form name>.Show
End Sub


Do not use the load method, as this just loads the form but does not make it visible. Besides, Show option automatically loads it anyway.

Load <user form name>