[Pond]

Hi. I'm learning Visual Basic (in 21 days!) from a nice, fat, hardcover book. To make my life difficult, I'm using the Visual Basic functionality within Excel, rather than working with Visual Basic by itself. (A few reasons - we don't have Visual Basic at work, but we do have Excel. I also want to use Visual Basic to put together more advanced applications with Excel.)

So, the first few sample programs worked just fine. Now I've hit a snag.

The sample program I'm working on has three radio buttons and three images. You select which one of the images you want to move around by clicking the appropriate radio button. You then click anywhere on the form and the image then moves to there.

OK. The first problem I had was with the MouseDown (mouse click) event. It isn't clear to me how to tie a MouseDown event to an Excel sheet.

So I looked for a workaround. I added an image 'object' behind the radio buttons and the images, and sent it to the back. It's basically working as a background. I could then associate a MouseDown event with this background image.

The program now works. I click somewhere on the background image, and the selected image moves there.

The problem now is that the background image 'receives' the focus when you click on it, bringing it to the foreground, obscuring everything else. Once the mouse pointer is moved off the background image, the image again reverts to the background, letting you see the three radio buttons and the three images.

My question is - how do I stop the background image jumping into the foreground when I click on it? Or how do I send it back into the background immediately after I've clicked on it? Or is there maybe some other object I should be using to link to the MouseDown event? Or is there some way I could shift the focus to another object on the sheet which would take the focus away from the background image?

[SabreWolf3]

Hi Pond,

I threw an example workbook together rather quickly, that will show you how to accomplish what you want in two ways. The first is a UserForm, and the second is in a sheet.

Move_Images.xls

See if that does what you expect, and then you can let me know if you have any further questions. I'll be gone for the weekend, but I'll return on Monday!

Regards,
Richard

[Pond]

Thanks heaps, Richard. That'll make getting through the rest of the book a lot less trial and error.

You threw it together rather quickly? Man oh man. It looks way better than my first attempt, and even better than the example in the book...