Results 1 to 1 of 1
2013-09-13, 15:06 #1
- Join Date
- Oct 2004
- Thanked 0 Times in 0 Posts
Is there a Free Form ActiveX shape for Excel 2010 VBA?
I made this workbook with an ActiveX image of a map on one sheet and information about points on the map on another sheet. I have that information pop up when I move my mouse to those points on the map. I've done that by overlaying other ActiveX images on top of the map and using the mousemove event of those images to pop up a modeless userform which I hide using the mousemove event of the map when I move the cursor off the point of interest. It all works great except I don't want the images that cause the pop ups to block the map so I made them transparent. The trouble is, the shape of the images (a simple box or rectangle) doesn't match the shape of the thing on the map. So the pop up sometimes appears when I don't expect it or doesn't appear when I do!
Is there any way to change the shape of an ActiveX control (I used "Image" but I guess I could use any ActiveX control) so I can make it match the shape I'm trying to get the pop for?
Any suggestions would be most welcome! Thanks for reading this far.
Last edited by VBA-Bumbler; 2013-09-13 at 15:08.