Hiding / unhiding pictures based on cell value

[supern0va]

Hi,

The last few days I've been working on a multiple choice quiz in excel.
I have a working version that picks questions from a column and answers from another, and presents it to the user. See attached.

Now I want the questions for chapter 1 to be pictures instead of text. I added some dummy pics in the doc I attached.
I used this tutorial.
It is supposed to hide all pictures and then display one on a specified location [U]if[U] that picture's name corresponds to a cell value (which is a vlookup formula).

But I get an error on the following line

Please Login or Register  to view this content.

Run-time error '13': Type mismatch

Complete code for that sub:
(Me.pictures.visible should be false. Is still true in attached doc.)

Please Login or Register  to view this content.

Does anyone see what I'm doing wrong?

[patel45]

I can't find object pictures, you can try something like

Please Login or Register  to view this content.

[supern0va]

Hi Patel,

Thanks. Yes, .Left instead of .Right solved part of the problem.

I also tracked down the second part of the problem. There's a type mismatch because not only the jpegs are detected as pictures, but also the start and reset button
See for yourself.

Please Login or Register  to view this content.

gives 26 hits: 2 buttons and 24 pictures.

when I remove those buttons, the code above works fine but the sheet itself is useless. :s

The reason you didn't see pictures is probably because they were hidden by

Please Login or Register  to view this content.

I'm adding an updated version. Care to take another shot?

Thanks a bunch!

[supern0va]

WHOO! Well that was obvious :p I scrapped the buttons which were ActiveX controls and replaced them with form controls. Flawless victory