![]() |
Textboxes remembering previous entries
I have a Userform with around 25 textboxes on it. What I am wondering is it
possible to have the textbox remember previous entries in order to make it quicker when filling in my form. Example, if i enter "Tom" into the textbox is there anyway to make it so that the next time I enter "T" it will automatically bring up "Tom" or any other word that has been entered into the textbox that begins with "T". If not is it possible to allow the person entering data into the textboxes to copy an answer from one textbox and pasting it in another textbox because currently I can't right click on any of the textboxes. Thanks. |
Textboxes remembering previous entries
Maybe you could use a combobox instead--and give the users a list to choose
while allowing them to type. Try ctrl-c to copy and ctrl-v to paste in your textboxes. aintlifegrand79 wrote: I have a Userform with around 25 textboxes on it. What I am wondering is it possible to have the textbox remember previous entries in order to make it quicker when filling in my form. Example, if i enter "Tom" into the textbox is there anyway to make it so that the next time I enter "T" it will automatically bring up "Tom" or any other word that has been entered into the textbox that begins with "T". If not is it possible to allow the person entering data into the textboxes to copy an answer from one textbox and pasting it in another textbox because currently I can't right click on any of the textboxes. Thanks. -- Dave Peterson |
All times are GMT +1. The time now is 05:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com