I've done some more work and tried things a different way. I now have 9 questions in the question bank that have diagrams, these being questions 160 to 168, the pictures being stored as 160.jpg through 168.jpg in a folder on my Desktop called FRT images. I now also have a blank image 999.jpg.
Cells(2,8) [h2] is where the randomly generated question number is housed.
My code now is:
Qno = Cells(2, 8)
Select...
m1eyp
Last Activity: Aug 16 '05, 08:41 AM
Joined: Aug 13 '05
Location:
-
Picture to appear in Excel, conditionally
I have a revision question bank on Excel. Two of these questions (160 & 161) have accompanying pictures, that I want to appear if either question is randomly selected.
These images have filenames 160.jpg and 161.jpg respectively, and are in a folder on my Desktop called "FRT images". My randomly selected question number is in Cells(2,8). Here is my attempt (that doesn't work):
If Cells(2, 8) > 159...
No activity results to display
Leave a comment: