Mark has attended:
Excel VBA Intro Intermediate course
Excel Advanced - For Power Users course
Excel PowerPivot course
Excel Dashboards for Business Intelligence course
Tooltip
I have some ActiveX buttons which add/remove lines to a line chart, what I'd like is a tooltip to appear when the user hovers over each button giving them a more detailed definition.
HELP!
RE: Tooltip
Hi Mark
Thanks for getting in touch. Unfortunately the ActiveX controls don't have an associated property for accessing the ToolTip or ControlTip.
You'll have to be a little more creative, using in-cell comments or other shapes. Here are a couple of links exploring these options:
http://www.ozgrid.com/forum/showthread.php?t=154042
http://www.mrexcel.com/forum/excel-questions/51535-tooltip-form-buttons.html
I hope you find a solution that works for you.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Tooltip
Thanks Gary - I've managed to find a work around by recording a macro of me selecting a cell behind the command button and then doing an input message via Data Validation and then assigning it to the commandbutton_mousemove
RE: Tooltip
Hi
Very creative!
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
