Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-29-2014, 09:35 AM
Marrick13 Marrick13 is offline Macro to extract AutoTextList Field Screen Tip text Windows XP Macro to extract AutoTextList Field Screen Tip text Office 2010 32bit
Competent Performer
Macro to extract AutoTextList Field Screen Tip text
 
Join Date: Jun 2006
Posts: 102
Marrick13 will become famous soon enough
Default

Not really, bu that may be because my brain is frying at the moment (working on another macro that captures screen tips only that are hyperlinked-based, and can use the same code as for the AutoTextList tips with only a few changes).



One thing about your revision...I still want to have a count of the AutoTextList screen tips in the document. For one thing, if the macro is run in a document without any such tips, it produces an error, and for another, I want to display a friendly msgbox that I had in an earlier version. Your 'fcnFieldData' function provides the count in the 'lngCOunt' variable, but for some reason, I can't get that value into the main module. I thought that by declaring a variable above the procedure (just below Option Explicit), its value would be available anywhere within the module. But when stepping thru the code, the variable shows zero in the 'Extract_AutoTextList_ScreenTip' module.

Can't I use your 'fcnFieldData' function to both get the page number AND the screen tip count?
Reply With Quote
Reply

Tags
autotextlist, extract, field



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to extract AutoTextList Field Screen Tip text Macro to find text and replace with form field containing that text iiiiifffff Word VBA 16 06-04-2016 01:47 AM
Macro to find coloured text and replace with form-field/formtext containing that text tarktran Word VBA 1 11-26-2014 08:12 AM
Macro to extract AutoTextList Field Screen Tip text Word 2007 Macro Fillin Field to Text mhblake Word VBA 5 01-08-2014 08:22 AM
Autotextlist Gone Wilson Word 1 04-04-2010 02:44 PM
Macro to extract AutoTextList Field Screen Tip text Extract email address from field zssteen Excel 1 06-19-2009 02:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:03 AM.


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