Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,560
Default worksheet image control appearance change (and back) with mousemov

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,163
Default worksheet image control appearance change (and back) with mousemov

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trouble with Image Control on a worksheet MChrist Excel Worksheet Functions 0 August 19th 05 01:18 PM
Programatically control picture property of Image control Brassman[_5_] Excel Programming 5 May 24th 05 09:32 PM
How do I make Excel worksheet tabs change appearance when chosen . fentrkn Excel Discussion (Misc queries) 1 March 14th 05 05:36 PM
Embedded word doc changed to image-need to change back to word. cflores Excel Discussion (Misc queries) 0 January 23rd 05 06:45 AM
copy shape image into image control Luc Benninger Excel Programming 2 July 15th 04 11:14 AM


All times are GMT +1. The time now is 01:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"