Previous Topic Next Topic

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 4478 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



Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses
Excel - To generate unique ID
wliang -
ferg -

4 responses
Any auto clicker for Xbox One?
vic11con -
julietdcosta -

13 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses