If you want to show any image on mouse-over on command button
Goto Developer Tab -> Insert -> choose label in Active x (add it to the sheet)
Goto Developer Tab -> Insert -> choose command button in Active x (add it to the sheet , and paste on the top of label)
Note Labels size should be bigger than command buttons size( You need to paste or add command button over the label)
Add a shape which you wanna show on the mouse over and give it some name
For example Mouse_t_1
To change the name of image . Select image and type name in the below box ( left to the forumla tab)
Goto label and right click choose property
Goto Worksheet module and add below code to it
Private Sub CommandButton1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
ActiveSheet.Shapes("Mouse_t_1").Visible = True
Private Sub Label1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
ActiveSheet.Shapes("Mouse_t_1").Visible = False
Logic: Label size is bigger than command button and command button is pasted or added over label. When you will keep the mouse on command button it will make the shape visible and when you remove the mouse button the label( mouse over) will make the shape invisible
Macro to import data from SQL using ADO connection string: Sub Import_data_from_SQL() ' Tools -> References -> Microsoft Active...
Please make sure that you have the latest Version Tool Last Updated on 17 Feb, 2012 Version 1.6 English Version For Excel 2007 &...
Adding Marquee in Excel worksheet Step 1 Step 2 Example 1 Continuous scrolling Add below code module1 or any new module Sub r...