Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 29
Default 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?

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,163
Default 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?


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 29
Default 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?



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 108
Default 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.


  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 29
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
select From dropdown and return another dropdown menu RE4379 Excel Discussion (Misc queries) 2 March 11th 10 03:09 PM
offer dropdown options based on another dropdown Conor Excel Discussion (Misc queries) 2 January 13th 06 04:28 PM
HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys Minitman[_4_] Excel Programming 0 February 22nd 05 08:50 PM
Textbox Bug? Missing/delayed update of textbox filled via VBA MarcM Excel Programming 0 November 4th 04 05:47 PM
Textbox Bug? Missing/delayed update of textbox filled via VBA MarcM Excel Programming 0 November 4th 04 05:43 PM


All times are GMT +1. The time now is 02:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"