+ Reply to Thread
Results 1 to 3 of 3

runtime error on listbox click

  1. #1
    Forum Contributor
    Join Date
    09-15-2012
    Location
    Jamaica
    MS-Off Ver
    Microsoft 365
    Posts
    244

    runtime error on listbox click

    Hello, I found a piece of code online that i am trying to use, but its giving me an error. If i run the code in the workbook that i found online it works, but if take that code and put in the workbook i am working on it fails, see code below:

    Please Login or Register  to view this content.
    The code line that it is failing on, what exactly is that code line doing?

  2. #2
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,565

    Re: runtime error on listbox click

    The code line that it is failing on, what exactly is that code line doing?
    It is populating 12 textbox controls (textbox1, textbox2...) with each of the 12 columns from the ListBox1 list box control.

    What are you trying to do?
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

  3. #3
    Forum Contributor
    Join Date
    09-15-2012
    Location
    Jamaica
    MS-Off Ver
    Microsoft 365
    Posts
    244

    Re: runtime error on listbox click

    Thank you Trebor76, that corrected the issue on point. I am actually rebuilding a userform i found online, but based on my question you would have realized that i am a "noobie". Learning as i go along.

    Thanks again.

+ 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. Runtime Error Listbox
    By matthew290683 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-27-2012, 01:58 AM
  2. [SOLVED] ListBox Click problem
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-19-2012, 10:39 AM
  3. Prevent ListBox Click Event Until Mouse Click
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2011, 12:23 PM
  4. Listbox Click event
    By scottintexas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2008, 11:11 AM
  5. [SOLVED] Click events not working when added during runtime
    By crazybass2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-10-2006, 11:09 AM
  6. ListBox Click...
    By tom in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-03-2006, 01:40 PM
  7. [SOLVED] listbox click event help
    By Michael Malinsky in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-23-2005, 05:30 PM
  8. click event on listbox
    By CStephenson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2005, 03:06 PM

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