Excel VBA User Form [Closed]

Report
Posts
1
Registration date
Wednesday December 21, 2011
Status
Member
Last seen
December 22, 2011
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!