Show or hide a control (image)

**tracktor** · 09-16-2009, 11:50 PM

How can I show an image when I enter a cell then hide the image when I leave the cell?

In other words if I enter, tab, or click on cell C3 a control becomes visible (in this case an image control), then if I tab, click or enter any other cell the control is hidden.

**Trebor76** · 09-17-2009, 02:30 AM

Hi tracktor,

The following Worksheet_SelectionChange event macro shows or hides a shape (Oval 1) depending on whether C3 is the active cell or not (respectively) on the sheet the code is assigned to:

Please Login or Register  to view this content.

HTH

Robert

**Trebor76** · 09-17-2009, 10:07 PM

Apart from breaching Rule 8 of this forum rules, it's plain forum etiquette to state that you're posting the same question on another forum (cross-posting) to save anyone (like me) wasting time trying to help when the issue has already been solved.