ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   TEXTBOX DROPDOWN (https://www.excelbanter.com/excel-programming/330173-textbox-dropdown.html)

jase[_2_]

TEXTBOX DROPDOWN
 
Some textboxes that I use on the web have a function where they
remember the previous entries that have been typed into them, and
either show the user in the form of a dropdown or complete the spelling
of the users entry:

is there a way to use the registery to do the above?
i suppose to make a textbox dropdown the 5 most recent entries is gonna
be either impossible or involve a lot of API calls - any workaround
ideas out there?


K Dales[_2_]

TEXTBOX DROPDOWN
 
Don't know why you would need to use the registry; you could create a range
in your workbook - on a hidden sheet if needed - and store the last 5
selections there. You would need, of course, to maintain this list (every
time user makes a selection, update it and also check for duplicates, etc.)
but it does not seem to be to hard to implement, to me.

"jase" wrote:

Some textboxes that I use on the web have a function where they
remember the previous entries that have been typed into them, and
either show the user in the form of a dropdown or complete the spelling
of the users entry:

is there a way to use the registery to do the above?
i suppose to make a textbox dropdown the 5 most recent entries is gonna
be either impossible or involve a lot of API calls - any workaround
ideas out there?



Robert Bruce[_2_]

TEXTBOX DROPDOWN
 
Roedd <<jase wedi ysgrifennu:

Some textboxes that I use on the web have a function where they
remember the previous entries that have been typed into them, and
either show the user in the form of a dropdown or complete the
spelling of the users entry:

is there a way to use the registery to do the above?
i suppose to make a textbox dropdown the 5 most recent entries is
gonna be either impossible or involve a lot of API calls - any
workaround ideas out there?


If you don't mind distributing an extra control with your app:

http://www.devx.com/vb2themax/CodeDownload/19794

--
Rob

http://www.asta51.dsl.pipex.com/webcam/

This message is copyright Robert Bruce and intended
for distribution only via NNTP.
Dissemination via third party Web forums with the
exception of Google Groups and Microsoft Communities
is strictly prohibited and may result in legal action.



jase[_2_]

TEXTBOX DROPDOWN
 
is there a property that a text box has to show a dropdown of these 5
selections: or are you talking more of a sort of autocomplete type of
textbox? : or are you suggeting using another type of control?

help appreciated

Jason

K Dales wrote:
Don't know why you would need to use the registry; you could create a range
in your workbook - on a hidden sheet if needed - and store the last 5
selections there. You would need, of course, to maintain this list (every
time user makes a selection, update it and also check for duplicates, etc.)
but it does not seem to be to hard to implement, to me.

"jase" wrote:

Some textboxes that I use on the web have a function where they
remember the previous entries that have been typed into them, and
either show the user in the form of a dropdown or complete the spelling
of the users entry:

is there a way to use the registery to do the above?
i suppose to make a textbox dropdown the 5 most recent entries is gonna
be either impossible or involve a lot of API calls - any workaround
ideas out there?




jase[_2_]

TEXTBOX DROPDOWN
 
having a lot of trouble moving this .exe file around - gets flagged as
a virus all over the place!
any other ideas fells?

help appreciated
Jason



All times are GMT +1. The time now is 05:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com