LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22
Default Change CommandButton Picture

How would you use VBA to change the bitmap picture assigned to a command
button on a worksheet?

I'm playing with using the mouseover event to simulate a mouse roll-over as
follows:

------------------------

Private Sub CommandButton1_MouseMove(ByVal Button As Integer, ByVal Shift As
Integer, ByVal X As Single, ByVal Y As Single)

debug.print CommandButton1.picture 'brings up the number of the current
bitmap, whatever the number means

***change picture to mouse-over picture***

End Sub
------------------------
Regards,
Wayne C.


 
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
Displaying a picture by pushing CommandButton Jean[_4_] Excel Programming 4 February 14th 05 11:39 AM
Can You Change A CommandButton Code Using A Macro? Donna[_7_] Excel Programming 4 February 11th 05 08:38 AM
How Do you Change The Color Of The CommandButton That You Just Prshed Minitman[_4_] Excel Programming 2 October 5th 04 05:44 PM
CommandButton Caption change via macro PCLIVE Excel Programming 3 September 20th 04 08:29 PM
Change CommandButton Caption Claude Excel Programming 4 July 16th 04 04:18 PM


All times are GMT +1. The time now is 01:37 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"