quiz: selection of cells of interest on picture

Hi all,

I will first try to explain the set-up of the quiz.
One must click a button and a random picture is selected from a file. One picture displays two different cells: positive and negative. Only the positive cells need to be selected. At the end of the session, after clicking the button 'solution', the correctly selected positive cells are indicated in green and the non-selected positive cells are indicated in red.
Is this possible using VBA?
I already managed to randomly select the pictures clicking a button, but I have no clue on how to indicate the positive and negative cells...

Thank you in advance,

Kind regards,
Veerle Bogaert

Hi,

The link for uploading the file doesn't seem to work... When I hit the button, I get a pale yellow rectangle.
Is it ok that I give you the code and a picture of the expected results?

Regards

Hi,

With the help of the administrator (Thank you very much!), I managed to attach the file.
If you have any questions, please do not hesitate to contact me.

Thanks!

I have uploaded a pdf file explaining which cells are positive and which cells are negative.
The user should be able to choose to click the cells on the photo he thinks is positive. An black oval should appear around the cell when selecting it.
After hitting the 'solution' button (not added to the file yet), this oval should turn green when correctly selected.
When positive cells were not selected by the user, a red oval should appear around the cell.

One way to manage this type of test is edit all pictures and put numbers near all cells (1,2,3..) and then ask user to choose correct number (this way is much more easier to process answers & results). I have some ready solutions, posted somewhere on this forum.
Other option could be UserForm. Load picture to UserForm and then create some elements above this picture - right over Cells. If user click on one of these elements - something happen. But in this case you should have positions of those elements for each picture (because cells on them can be enywhere). This is difficult way, but this can be closer to result you wish to get.

Well, I've played around this and built up small Userform with some Image and Button elements.
After you run the test you will see 3 pictures on a form, you can choose your answer by clicking on a picture - picked answers will highlighted with yellow background.
If you changed your mind - you can click on already chosen (yellow) picture and your chose will be canceled.
You can zoom each picture to look at it closer (quality of pictures are bad, but I'm just trying to tell you my idea). When you click on zoomed picture - it will be closed.
After you are sure about your chose - press Solution button. Correct answers are 1 and 2 pictures, if you will choose different options - pictures will be highlighted.
Once again - this is not completed solution, this is just demonstration of my idea how your task can be done.
To make it work - you will need lot of pictures, think about random picture loading on a form, count correct answers and so on.

Hi,

Thank you very much for your help!
So, the best way to go is to set up a userform for each picture?
How can I add the ovals? The rotation of these ovals depends on the alignment of the cells.

Regards

Hi,
I'm not tellin you that userform is the best way, just one of the possible ways. Your requriment seems quite complicate. You want to draw shapes on some existing picture, you also wish to draw those ovals rotated.
Do you really need to load whole picture (with several cells on it)?
If I got it right - you wish to make some solution where users could look at cells then choose positive cells and check if their choise was correct. I would suggest to think about different way to show cells (not on one picture).

One picture and two buttons under: "positive" and "negative". This is possible.
But you wrote in post #1 "One picture displays two different cells: positive and negative". How to check correct answer? If one picture contains 2 positive and 1 negative cell? I click "positive".. is this correct?
If whole picture is important then may be we can display one big picture (with all cells) and under this picture show smaller pictures of cells only? This way you can see all cells together and select positive cells from smaller pictures?
cells.jpg

Hi kasan,

The cell of interest on the picture could be indicated with an arrow. Only one cell can be assessed per picture.

However, your idea is better. Does this mean that for every picture, I should first save different 'sub-pictures' on the hard disk?

Regards

Yes, you should cut "sub-pictures" and save them as separate files.
Just give some reasonable names for files to access them easy. I would use numbers as reference between big pic and sub-pictures.
Like this:
Pic_big_1
Pic_cell_11
Pic_cell_12
...
Pic_big_2
Pic_cell_21
Pic_cell_22
...

many thanks!