Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #12  
Old 11-29-2014, 09:15 AM
gmaxey gmaxey is offline Macro to extract AutoTextList Field Screen Tip text Windows 7 32bit Macro to extract AutoTextList Field Screen Tip text Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,617
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

Marrick,

I'm not so good with arrays either but the more I use them the less formidable they become. Same goes for classes.

You may observe here that I used a dynamic array. It way seem odd that I didn't have a primary element for each field. Instead the primary elements were page number, displayed text, and screentip text. Then each primary element had a unique secondary element for each field. So the final arrays dimension was something like this (2, 8) instead of (8, 2). There reason for that is Redim Preserve only preserves the final dimension. Make sense?
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
 

Tags
autotextlist, extract, field

Thread Tools
Display Modes


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 04:48 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