Reply
 
LinkBack Thread Tools Display Modes
Old 10-22-2010, 07:42 PM   #11 (permalink)
Senior Member
 
Join Date: Mar 2006
Location: Novato (20 miles north of San Francisco)
Posts: 445
fryeguy is on a distinguished road
Default

To hard code "AV -" as a prefix to your page numbers in the text box the macro creates simply edit the line towards the bottom that reads:


TOCEntry.Text = TOCEntry.Text + CStr(PageToIndex.Index) + vbTab + PageToIndex.Name + vbNewLine

and make it say:


TOCEntry.Text = TOCEntry.Text + "AV -" + CStr(PageToIndex.Index) + vbTab + PageToIndex.Name + vbNewLine

Thanks for sharing this macro Tim. Very helpful.

Last edited by fryeguy; 10-22-2010 at 08:32 PM.
fryeguy is offline   Reply With Quote
Old 10-22-2010, 08:37 PM   #12 (permalink)
Senior Member
 
Join Date: Mar 2006
Location: Novato (20 miles north of San Francisco)
Posts: 445
fryeguy is on a distinguished road
Default

If you want to type in a prefix try this revised macro. It pops up a dialog prepopulated with "AV - " and lets you type in an alternative including blanking out the value.
Attached Images:
File Type: jpg SheetListPrefixForm.JPG (14.6 KB, 0 views)
Attached Files:
fryeguy is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update Product in Master Table deletes accessories Tim Neill Manage My Product Data 1 09-24-2008 03:01 PM
Syncing Master Table D_N Manage My Product Data 2 12-05-2007 01:30 PM
report in word (resize image and formatting table) marco 'How Do I' Questions 1 02-15-2007 08:36 AM
Remove items from Master Table kbwill 'How Do I' Questions 4 10-20-2006 04:06 PM
Master Table Locking RichardMaris General Section 0 04-18-2006 09:35 PM


All times are GMT. The time now is 04:45 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.3.0
D-Tools, Inc.