98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Tooltip
Tooltip
Resolved · Medium Priority · Version 2007
Tue 4 Dec 2012, 16:30Delegate Mark said...
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!
Wed 5 Dec 2012, 09:26Trainer Gary said...
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
Wed 5 Dec 2012, 10:10Delegate Mark said...
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
Wed 5 Dec 2012, 10:14Trainer Gary said...
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
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Edit and format multiple worksheets in one operationTo select two or more non-adjacent worksheets, click on the tab of each worksheet, while holding down the [CTRL] key. |
