I have a simple User form which comprises the following form controls:
a) Customer name (Combo box)
b) Customer address1 (Text box)
c) Customer address2 (Text box)
d) Customer address3 (Text box)
e) Town/City (Text box)
f) Postcode (Text box)
I want an event whereby selecting a customer from the Combo box dropdown list automatically populates the text box controls beneath.
I've tried using Vlookup against my Customer sheet but keep getting compilation errors. Is there a standard code that would fit this requirement ?