Hey!
I am sorry if this has been posted here before, but I'm working on this userform(Attached).
I need to fill in build a combo box that will have various cities. When I choose a particular city I want the "Customer Number" to automatically fill with the first 3 alphabets of the city or some other alphabets that are used to abbreviate the city's name. for eg, I choose Hyderabad from the combo box and the customer number should look like "HYD001" or "HYD1"
Can someone just mention a piece of code that can help me get started. I am stuck here and can't find a way through.
Thankyou for any help you put forward
Bookmarks