I need an image in my document to automatically change based on the selections in two other cells
Cell B2 contains a Combo Box with a Drop Down list
Cell C2 contains a Combo Box with a Drop Down list
Cell B10 contains a formula that uses the contents of cells B2 and C2 to output the file name of the image that needs to be shown
The images are saved in a folder named PICS, there are several thousands of them
The to left corner of the image needs to align with Cell F2
The image needs to automatically change when either cell B2 or cell C2 changes, or when the formula updates the contents of cell B10
I've tried getting this to work on my own, but I have no experience with VBA or Macros and need help.
Cell B2 contains a Combo Box with a Drop Down list
Cell C2 contains a Combo Box with a Drop Down list
Cell B10 contains a formula that uses the contents of cells B2 and C2 to output the file name of the image that needs to be shown
The images are saved in a folder named PICS, there are several thousands of them
The to left corner of the image needs to align with Cell F2
The image needs to automatically change when either cell B2 or cell C2 changes, or when the formula updates the contents of cell B10
I've tried getting this to work on my own, but I have no experience with VBA or Macros and need help.