Previous Topic Next Topic

Excel VBA User Form

Closed
oggow Posts 1 Registration date Wednesday 21 December 2011 Status Member Last seen 22 December 2011 - 22 Dec 2011 à 13:56
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 27 Dec 2011 à 14:43
Hello, I am quite new to Excel VBA and I , desperately, need an expert help.

am trying to create a user form that generates customer IDs made of 9 digits, the first 2 digits represent the year, for expample a coustomer joins in 2011, their number will be 110003434. I managed to write a code to do it manualy but I need to programe to generate them.

Kind Regards,

Sharleen



Related:

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
27 Dec 2011 à 14:43
what you mean you wrote a code to do it manually but want it to be done via program ?
Sound like you have the program and are not sure how to call that program inside some other macro. If that is the case, you can simply make a call to this macro as
Call generateCustomerId

Similar discussions

Nero 6 serial number
Yoseph12 -
Ambucias -

1 response
IDM SERIAL NUMBER
fisb -
Ambucias -

1 response
need a serial number for Nero 6
DennisSamuels -
Ambucias -

1 response
Any auto clicker for Xbox One?
vic11con -
julietdcosta -

13 responses
Convert number to spelling
Sukumar -
mrwagh85 -

28 responses