Userform Picture and text selection


Well-known Member
Oct 4, 2018
Good Morning,

I was wondering two things, both interrelated:

1. I have a drop-down box that selects a bunch of info from an array using vlookup formulas and vba coding. Is it possible to have a collection of pictures saved on a sheet in the workbook and then the background of a userform as the picture based on the dropdown box value (so if there are three items in the array, three pictures, then changing options 1, 2, and three in the drop down will change the background picture to 1, 2, or 3 accordingly when the userform opens?)?

2. There are labels in front of the picture. They are hard to see (black) with a darker background, but not all pictures line up the same. As such, is it possible to make the text automatically change color to be opposite (say white, black, or grey) whatever the picture is in that area? It can be a different array of colors, just wondering on the concept, really.

3. Is it possible to have (this one seems easier) to have a user select (via cmd button) a picture in an "open" window, then vba loads the picture in, sets the size correctly (say the userform is 200 tall and 300 wide and the image has to be stretched), and then categorize it via a dropdown (to know who it associates with)?


Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...