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