I have an Excel chart for which I am tracking 5 items YTD. These 5 items have a 4 digit numerical code and explanation such as: "1234 - Object is the wrong color." To eliminate confusion on the chart, I have removed the explanation and track these items by code number only so they now are 1234, 1567, 2876, etc..
I have been attempting to create a "Mouseover CommandButton" to display a picture or text pop-up that will allow the users to see the whole code and explanation. This information should be displayed when the mouse pointer is moved over the CommandButton, and disappear when the mouse is moved from the button. After having created Label1, Here is the VBA code I am attempting to use:
First trial resulted in my "CommandButton1" turning Grey on mouse over, and Blue on mouse off, and, no picture is displayed. I am not interested in my command button changing colors.Please Login or Register to view this content.
So I entered a path to the picture:
Image1.Picture = stdole.LoadPicture("C:\Documents\My Pictures\Image 5.jpg")
The result of this trial produces Run-time error '76' Path not found and brings up the Debug with Image1.Picture = stdole.LoadPicture("C:\Documents\My Pictures\Image 5.jpg") highlighted yellow.
I have tried numerous variations and reiterations without success. Worksheets attached.
Please point out where I am missing the mark.
Thank you in advance.
Bookmarks