Excel VBA User Form

Closed
oggow Posts 1 Registration date Wednesday December 21, 2011 Status Member Last seen December 22, 2011 - Dec 22, 2011 at 01:56 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 27, 2011 at 02:43 PM
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



1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Dec 27, 2011 at 02:43 PM
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
0