Hello All.

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.

I'll explain:

Sheet 1:

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.

I would also like an answer to this question....

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.