rplazzotta
New Member
- Joined
- Oct 28, 2021
- Messages
- 41
- Office Version
- 2019
- 2010
- Platform
- Windows
Can anyone help with my BalloonToolTips class? It works in Excel 32-bit (W7 and W10) but not in Windows 10 Excel 64-bit, even though it compiles without errors.
It's old VB6 code that I've adapted for VBA (VBA only exposes hWnds for Frames and Listboxes).
So I put any controls other than the above that require a multiline "ControlTipText" in a caption-less Frame with the Userform's bordercolor and I put the control's ControlTipText in that of the Frame.
It's the only way I've found to provide multiline tooltips for such controls.
But they just don't show in Excel 64-bit. Any help would be greatly appreciated.
http://www.wot.fr/BalloonToolTipDemo.zip
Richard
It's old VB6 code that I've adapted for VBA (VBA only exposes hWnds for Frames and Listboxes).
So I put any controls other than the above that require a multiline "ControlTipText" in a caption-less Frame with the Userform's bordercolor and I put the control's ControlTipText in that of the Frame.
It's the only way I've found to provide multiline tooltips for such controls.
But they just don't show in Excel 64-bit. Any help would be greatly appreciated.
http://www.wot.fr/BalloonToolTipDemo.zip
Richard