sassriverrat
Well-known Member
- Joined
- Oct 4, 2018
- Messages
- 655
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)?
Thanks!
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)?
Thanks!
