WBS Numbering With VBA
Budget: $10 – $30 USD
POST ORIGINAL:
https://modjeska.us/project-style-wbs-numbering-in-ms-excel/
PROBLEMA A RESOLVER:
"
I have used this macro and modified a bit as per my requirement. in my field of work we usually use 001.001.001 format, so i have modified below command in the code:
For aloop = 0 To depth
wbs = wbs & “.00” & CStr(wbsarray(aloop))
Next aloop
But then when the number reaches double digit it looks like 001.0012.0015 but what I am looking for is 001.012.015 so can you help me in modifying this code."
RESULTADO ESPERADO:
AUTOMATIC WBS NUMBERING FORMATO : 000.000.000
https://modjeska.us/project-style-wbs-numbering-in-ms-excel/
PROBLEMA A RESOLVER:
"
I have used this macro and modified a bit as per my requirement. in my field of work we usually use 001.001.001 format, so i have modified below command in the code:
For aloop = 0 To depth
wbs = wbs & “.00” & CStr(wbsarray(aloop))
Next aloop
But then when the number reaches double digit it looks like 001.0012.0015 but what I am looking for is 001.012.015 so can you help me in modifying this code."
RESULTADO ESPERADO:
AUTOMATIC WBS NUMBERING FORMATO : 000.000.000
Related categories:
Excel VBA