Macros for mouseover to popup data from another spreadsheet and disappear when mouse leave

**Atan4** · 08-05-2013, 11:12 PM

Hi,
I'm struggling to find the macros to pop up data from another spread sheet when mouse points to the command button and pop up disappear when mouse leave it. Somebody please help me. Thanks.

**patel45** · 08-06-2013, 01:43 AM

There IS NOT a mouse-over event. The closest you are going to come, without selecting cells is to add a comment box to a cell, then you can mouse over the cell and display the content in the comment box.

**vbc22** · 08-06-2013, 01:58 AM

Here's a nifty way you can do it.

Add a MouseMove event handler to your CommandButton and call the following ShowPop() method:

Please Login or Register  to view this content.

Attached is your original Excel file with working code. This can help you get started...you can refine the placement of the popup form and modify how you want to set the content on the popup form.