View Single Post
 
Old 11-29-2014, 09:35 AM
Marrick13 Marrick13 is offline Windows XP Office 2010 32bit
Competent Performer
 
Join Date: Jun 2006
Posts: 103
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