Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-15-2018, 12:38 AM
optima optima is offline sequential number and macro Windows 7 64bit sequential number and macro Office 2013
Novice
sequential number and macro
 
Join Date: Nov 2017
Posts: 5
optima is on a distinguished road
Default 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
Attached Images
File Type: png eg.PNG (6.6 KB, 30 views)
Reply With Quote
  #2  
Old 05-15-2018, 03:35 AM
macropod's Avatar
macropod macropod is offline sequential number and macro Windows 7 64bit sequential number and macro Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 05-15-2018, 04:01 AM
optima optima is offline sequential number and macro Windows 7 64bit sequential number and macro Office 2013
Novice
sequential number and macro
 
Join Date: Nov 2017
Posts: 5
optima is on a distinguished road
Default

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}}}
Reply With Quote
  #4  
Old 05-15-2018, 04:09 AM
macropod's Avatar
macropod macropod is offline sequential number and macro Windows 7 64bit sequential number and macro Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #5  
Old 05-15-2018, 04:46 AM
optima optima is offline sequential number and macro Windows 7 64bit sequential number and macro Office 2013
Novice
sequential number and macro
 
Join Date: Nov 2017
Posts: 5
optima is on a distinguished road
Default

yep i did use ctrl f9 , and manually typed it all in
Reply With Quote
  #6  
Old 05-15-2018, 04:51 AM
macropod's Avatar
macropod macropod is offline sequential number and macro Windows 7 64bit sequential number and macro Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

See attached.
Attached Files
File Type: docx SEQ FILLIN.docx (25.1 KB, 21 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 05-15-2018, 11:01 PM
optima optima is offline sequential number and macro Windows 7 64bit sequential number and macro Office 2013
Novice
sequential number and macro
 
Join Date: Nov 2017
Posts: 5
optima is on a distinguished road
Default

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
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
sequential number and macro Sequential Numbering A Document When The Same Number Appears Twice on a Page Auxiliaryman COB Word 3 08-02-2017 03:10 PM
sequential number and macro 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
sequential number and macro 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

Other Forums: Access Forums

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


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