Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The user makes a choice by clicking on one of a number of small image
controls. I thought it would be nice if the image appearance could be changed with mousemove (and now for the difficult bit) and changed back when the mouse is moved away. Maybe using additional image control(s) bordering the original image to change the original image appearance back to it's default state? TIA -- David |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Your idea can work: here is a simple demo; Image1 is a blank image control
just slightly larger than Image2, forming a small "frame" around it: Private Sub Image1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single) Range("A1").Clear End Sub Private Sub Image2_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single) Range("A1").Value = "IMAGE" End Sub You can see that A1 responds to the image while the mouse is over it and clears when you move away (i.e. when you move over Image1). You could replace the code within the subs: Sub Image2_MouseMove() could use the image control properties to highlight Image2 in whatever way you decide and then Image1_MouseMove() would reset it to the default state. -- - K Dales "David" wrote: The user makes a choice by clicking on one of a number of small image controls. I thought it would be nice if the image appearance could be changed with mousemove (and now for the difficult bit) and changed back when the mouse is moved away. Maybe using additional image control(s) bordering the original image to change the original image appearance back to it's default state? TIA -- David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trouble with Image Control on a worksheet | Excel Worksheet Functions | |||
Programatically control picture property of Image control | Excel Programming | |||
How do I make Excel worksheet tabs change appearance when chosen . | Excel Discussion (Misc queries) | |||
Embedded word doc changed to image-need to change back to word. | Excel Discussion (Misc queries) | |||
copy shape image into image control | Excel Programming |