#1
|
|||
|
|||
sequential number and macro
I have a sheet of labels it contains roughly 24 labels now in the past the person would have to manually add the numbers in , I implemented seq field
but to make it easier i was hoping to add a macro with a pop up box to autofil the first label so that the rest would follow eg : the first label has the field with the command SEQ seqname \r291 , as you know it states to start at number 291 , but i am hoping to add a macro so that at the opening of the doc a box would pop up so that the user can change the 291 to what ever number |
#2
|
||||
|
||||
Simply insert a FILLIN field in the SEQ field to solicit the first number. For example:
{SEQ ID \r {FILLIN "First ID No." \d {SEQ ID \c}}} Each subsequent SEQ field would simply be coded as: {SEQ ID \n} When you open the document, press Ctrl-A, followed by F9 to trigger the FILLIN prompt (which will default to the last number that was input). Insert the new number and press OK. All the numbers will be updated. No macros required.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
thanks , i'm getting an error of "bookmark not defined"
i assume the syntax should be {SEQ ID \r {FILLIN 291 \d {SEQ ID\c}}} |
#4
|
||||
|
||||
Since the field coding doesn't use bookmarks, I'm not sure what that error means. Did you use Ctrl-F9 to create all the field brace pairs (i.e. { })? You can't simply copy/paste the field code from here or type those braces.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
yep i did use ctrl f9 , and manually typed it all in
|
#6
|
||||
|
||||
See attached.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
thanks so much , not sure what i was doing wrong in the firtst instance , but i follow your example doc and got it sorted out , thanks heaps
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sequential Numbering A Document When The Same Number Appears Twice on a Page | Auxiliaryman COB | Word | 3 | 08-02-2017 03:10 PM |
Word 10 Tables: Column to auto number 1.1, 1.2 etc in sequential rows | FrauBaker12 | Word Tables | 7 | 06-24-2016 11:52 PM |
I would like a function to add sequential numbers to a class number/name | Highlander01 | Excel | 5 | 01-22-2016 02:29 PM |
Sequential Numbering on Tickets Multiple number Sequences | skitchen | Word | 2 | 10-01-2013 06:41 AM |
Labeling sequential forms with a unique number | krau0231 | Word | 1 | 10-18-2012 03:33 PM |