- Aug 1, 2004
- 1,612
- 46
- 195
Hello Guys,
I'm having a bit of trouble working out how to do something in VB Script, im using it in excel.
Basically, I need to be able to add numbers to letters and then count up. I'm using it to generate user id's
For example,
Each user ID must start with LTS and then two letters and then two numbers. So the first ID's would be:
LTSAA01, LTSAA02, LTSAA03 and so on. Once it gets to 99 it would then change to AB and so on.
Basically I'm calling on this from another form, so rather than the user have to type the ID in, it is already filled in and then the next time a user goes to add another ID it would be generated from the previous but +1
Does this make sense?
Thanks
Dk
I'm having a bit of trouble working out how to do something in VB Script, im using it in excel.
Basically, I need to be able to add numbers to letters and then count up. I'm using it to generate user id's
For example,
Each user ID must start with LTS and then two letters and then two numbers. So the first ID's would be:
LTSAA01, LTSAA02, LTSAA03 and so on. Once it gets to 99 it would then change to AB and so on.
Basically I'm calling on this from another form, so rather than the user have to type the ID in, it is already filled in and then the next time a user goes to add another ID it would be generated from the previous but +1
Does this make sense?
Thanks
Dk