Re: [ExcelVBA] Drop Down question

 

Are you using a combo box? If so is it a forms combo box or an activeX combo box? or areyou using a validation list?

How is the list row source set up - Spreadsheet range, spreadsheet named range, typed list?  List filled by vba in the userform's initialisation event?  or what?

How is the data organised?  Is it alphabetical?

Regards

David Grugeon

On 7 November 2013 07:17, Jim Wagner <luvmymelody@yahoo.com> wrote:

I cannot seem to get it working to filter as I type. 

 

Jim Wagner

---

On Wednesday, November 6, 2013 2:00 PM, David Grugeon <yahoo@grugeon.com.au> wrote:

 

I am fairly certain this is the default behaviour of a combo-box.

The source needs to be in alphabetical order for it to work as the combo box just jumps to the next instance in the list which matches (or exceeds) the letters typed.

Regards

David Grugeon

On 7 November 2013 05:15, <luvmymelody@yahoo.com> wrote:

Hello all, 

Is there a way of having a user type in a drop down box and the values of the drop down filter as you type?

Thank You

Jim Wagner

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (7)

Recent Activity:

• New Members 2

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___