Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
select From dropdown and return another dropdown menu | Excel Discussion (Misc queries) | |||
offer dropdown options based on another dropdown | Excel Discussion (Misc queries) | |||
HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys | Excel Programming | |||
Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming | |||
Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming |