Quote:
Originally Posted by macropod
If one used a Style-linked multi-level list numbering format, the numbering for both levels could largely take care of itself that way, too. The problem remains though, as to how the code would 'know' when to change Styles.
|
Quote:
Originally Posted by gmaxey
As far as simply sequencing, I would insert a Seq Field where you want the numbering to appear and then update the field in the table.
However, for your basic question how is your macro supposed to know when the next number should be 3 or 3a? Or how long that sub-sequence should run before 3d becomes 4?
|
I was thinking that each time the user is asked if they want to add a new dimension...
Code:
If MsgBox("Add a new dimension?", vbQuestion + vbYesNo, "Inspection Report") <> vbYes Then Exit Sub
...the MsgBox can be replaced with a pop-up that gives them the option to continue with "single dimensions" or start a "multi-dimension". So if they select "single dimension" the code would add the next number in the sequence but if they selected "multi-dimension" the next number will have an "a" attached to it.
Then subsequent requests they would be asked to continue "multi" or move to next "single".
As I see it, the code would have to:
- Check the current rows number.
- Ascertain if a letter precedes the number.
- If Yes AND the user selected "Multi", keep the same number and add the next letter in the alphabet.
- If No AND the user selected "Multi", add the next number and add the letter "a" to it.
- If Yes AND the user selected "Single", add the next number only.
- If No AND the user selected "Single", add the next number only.
This would seem straight forward enough, but being a newbie it's a tad bit aggressive for me quite yet. If either of you can continue pointing me in the right direction, it would be most appreciated.
03-20-2016, 11:31 PM
Similar Threads
How do I do a Sequential Numbering?
Windows 10 
Office 2013
Hybrid Mode