I'm trying to make a VBA Form, that fills a Excel Worksheet, but I would like to make possible that some of the textboxes autofill while user is inputing.
Num Name Telephone
1 AAA 0000124
2 BBB 0000323
3 ABC 0000311
I would like that, on the form, when user enters "A",on the textbox, it auto-fills with the matching starting letters on the sheet: "AAA", and then when user enters "B", it changes for the next matching line: "ABC".
Can you please give me a hint on how to to this?
Thanks for your time.