+ Reply to Thread
Results 1 to 2 of 2

Combobox/Listbox Change even to populate values in it

  1. #1
    Forum Contributor
    Join Date
    02-20-2009
    Location
    bristol
    MS-Off Ver
    Excel 2003
    Posts
    882

    Combobox/Listbox Change even to populate values in it

    Hi All



    I am trying to write a code that will execute at the change even of the combobox/Listbox and when a character is typed in it then all the data from "DocumentType" field whose first character matches with the first character typed in Combo/Listbox will be stored in it.



    The following code doesn't work:

    Please Login or Register  to view this content.


    Any help would be much appreciated.



    Thanks

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    The criteria in the SQL statement is looking for Refs that begin with the string 'strText'.

    Try changing it to this.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Select Combobox and populate Listbox
    By kapoeira in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-07-2013, 06:19 AM
  2. [SOLVED] UserForm - Populate Combobox/Listbox with lookup formulas
    By macenmin in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-30-2013, 09:24 AM
  3. [SOLVED] Automatically Populate Listbox from ComboBox Selection
    By doglover in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2013, 01:51 AM
  4. In UserForm, how to populate a ComboBox/ListBox with a Range, defined by....
    By johnw993 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-07-2012, 11:06 PM
  5. ComboBox to Populate ListBox
    By Jamie0691 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-15-2012, 08:28 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1