Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to check previous entries in column for same contents | Excel Worksheet Functions | |||
How do I restrict cell entries that are determined by a previous l | Excel Discussion (Misc queries) | |||
retrieve previous entries | Excel Discussion (Misc queries) | |||
How to constrain input to previous entries | New Users to Excel | |||
Easy one: Remembering previous sheet name | Excel Programming |