+ Reply to Thread
Results 1 to 7 of 7

Managing multiple listboxes with one code

  1. 03-07-2013, 12:02 PM #1
    bulina2k
    bulina2k is offline
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    862

    Managing multiple listboxes with one code

    Hi everyone
    Because in my worksheet I have 10 listboxes i had to write ten such codes:

    Please Login or Register  to view this content.
    I'm trying to replace these 10 codes with something like :

    Please Login or Register  to view this content.
    wich isn't working... maybe you guys can help me with that?

    thanks alot!
    Reply With QuoteRegister To Reply
  2. 03-07-2013, 12:46 PM #2
    MickG
    MickG is offline
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Managing multiple listboxes with one code

    Try:-
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 03-07-2013, 12:49 PM #3
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Managing multiple listboxes with one code

    What type of listboxes are they?

    Can you attach a sample workbook.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  4. 03-07-2013, 06:16 PM #4
    bulina2k
    bulina2k is offline
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    862

    Re: Managing multiple listboxes with one code

    ok! thanks Mick! this is woriking perfect!
    now the problem escalates on 10 times LostFocus code and following that ideea...

    Please Login or Register  to view this content.
    is it possible to..

    Please Login or Register  to view this content.
    and because we dont know target.row maybe we can find it out from the position of the listbox on the sheet?
    thanks anyway! you are great!
    Reply With QuoteRegister To Reply
  5. 03-07-2013, 07:10 PM #5
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Managing multiple listboxes with one code

    Hello bulina2k,

    Welcome to the Forum!

    If you post your workbook it will be easier to create a working solution.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  6. 03-13-2013, 03:07 PM #6
    bulina2k
    bulina2k is offline
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    862

    Re: Managing multiple listboxes with one code

    Hi again,
    I chopped the file so now it contains only the relevant code.
    thanks alot
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 03-13-2013, 03:13 PM #7
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Managing multiple listboxes with one code

    Why do you have 10 listboxes?

    Can't you have one listbox?

    You could display that next to the relevant cell and populate it with the relevant data.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1