Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-13-2013, 10:33 AM
Carpie Carpie is offline Hyperlink in cell to trigger pop up text box Windows XP Hyperlink in cell to trigger pop up text box Office 2010 32bit
Novice
Hyperlink in cell to trigger pop up text box
 
Join Date: Aug 2013
Posts: 1
Carpie is on a distinguished road
Default Hyperlink in cell to trigger pop up text box

Hey all. I'm new to VBA programming but attempting to take over managing a VBA macro that was written by someone else.



In a nutshell, the macro creates pivot tables from the data in the various worksheets of the workbook. Some of the column labels are calculated fields and abbreviated. The user community is asking for a way to incorporate into the worksheet a way for them to see the definition of the column acronym and calculation. A suggestion was made just to add comments to the column heading cells so that if you need to reference the info, all you would need to do is hover your mouse over the comment.

Sounds easy. Unfortunately it doesn't seem that pivot tables support comments. Through the UI, I don't have an option to add a comment field if I right click on the column headings (as I do if I right click on a cell outside the pivot table). I forced a comment into the cell via VBA, but it doesn't pop up on mouseover like it should. I can also create it so it is visible by default and that works, they need to be hidden by default so as not to clutter the table.

If there is a way to make the comment feature work, I'm open for suggestions. Another option I'm considering is to just create something outside of the pivot table that the user can click on to trigger a text box to appear showing the definitions. I would prefer this be a subtle hyperlink above the pivot table that can be clicked as opposed to a bulky button.

Thanks in advance for your help!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlink in cell to trigger pop up text box How to set a hyperlink from a pp presentation into a CELL from an excel sheet Sabi PowerPoint 1 04-30-2013 06:36 AM
Hyperlink in cell to trigger pop up text box How to input the text of a cell into another cell automatically ? Juliet Excel 1 03-15-2013 03:25 AM
Hyperlink in cell to trigger pop up text box Trigger select in Powerpoint 2007 slothman2000 PowerPoint 2 06-06-2012 01:04 PM
Desperatly need help in trigger animations quinn307 PowerPoint 0 03-27-2011 08:52 PM
Auto-populate an MS Word table cell with text from a diff cell? dreamrthts Word Tables 0 03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft