954,568 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

VBA Excel Form Auto-Fill Textbox

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.

Smash919
Newbie Poster
1 post since Feb 2008
Reputation Points: 10
Solved Threads: 0
 

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

jerty
Newbie Poster
1 post since Sep 2009
Reputation Points: 10
Solved Threads: 0
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You