PDA

View Full Version : Solved: Remembering entries



thomas.szwed
04-15-2008, 08:59 AM
I have a userform which captures user data via text boxes and records this to my spreadsheet. Do you know if there is anyway to remember this information just like Google does when you begin typing something into its Search Box?

So when my user goes to enter repeated information they can easily enter stuff saving some time.

Many THanks

mdmackillop
04-15-2008, 10:32 AM
You can do this with a combobox using the RowRource property

thomas.szwed
04-17-2008, 01:46 AM
Do you enter things into a combo box like you can do on a textbox tho? Because my users will be entering new data sometimes.

Thanks

mdmackillop
04-17-2008, 02:38 PM
Nave a look at this (http://vbaexpress.com/forum/showthread.php?t=18874)

thomas.szwed
04-18-2008, 03:33 AM
is the range of data for these lists actually being stored pyhsically in the workbook itself then?

mdmackillop
04-19-2008, 02:15 AM
Data can be stored in a separate range or it can be extracted from previous entries (less efficient) or even stored in a separate workbook or text file. The choice is yours.