Macro for displaying an image based on a string value in a specific cell?

[bfigley]

Hi guys, this is my first post.

So I've been trying to set up an order form that has drop down menus and vlookup data with a separate sheet for the lookup tables. I want to set up a bunch of macros for each different option so that when a specific option is selected in each of the drop down menus, it displays a different image. Sadly, I am completely new to Visual Basic coding, but I have been looking around online and have a very basic concept of syntax. I was wondering if anyone would be able to shed some light on my conundrum and write a small bit of code that I could copy/paste into each macro for each image that I want to be shown. I know I'm asking a lot, but I'm completely stuck...

Thanks so much in advance!

 

[Myrko]

Sub Button5_Click()
Dim sheetName As String
sheetName = Range("Q1")
Sheets(sheetName).Visible = True
Sheets(sheetName).Select
End Sub

This kind of macro could make you unhide and open a sheet that has exact name as value of cell Q1.