+ Reply to Thread
Results 1 to 22 of 22

Multi Column List Box (14) in user form not working

  1. #1
    Registered User
    Join Date
    08-14-2016
    Location
    Dubai
    MS-Off Ver
    2013
    Posts
    11

    Post Multi Column List Box (14) in user form not working

    Dear Folks,

    I am having an excel sheet with 14 column of data and I create a user form with textbox and List box.
    My lsit box is showing only 12 column of data please help me.

    I am stuck badly. File attached for ready REFERENCE

    CA4079 Manpower Civil ID & GP - XXX.xlsm

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    7,151

    Re: Multi Column List Box (14) in user form not working

    You set the listbox to use columns A:L for its List property, which is only 12 columns. Just change that code in the Initialize event to use the correct range.
    Rory

  3. #3
    Registered User
    Join Date
    08-14-2016
    Location
    Dubai
    MS-Off Ver
    2013
    Posts
    11

    Lightbulb Re: Multi Column List Box (14) in user form not working

    Thanks for your reply

    Here is my file here I my lis box is getting populated with 14 column when loading but when I am searching data that time its creating problem.
    old data i not getting cleared and search result is getting mashup.
    Welder Master File_Final Ver1.2.xlsmWelder Master File_Final Ver1.2.xlsm

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    7,151

    Re: Multi Column List Box (14) in user form not working

    Your search code puts the entire list back into the listbox at the start - why?

  5. #5
    Registered User
    Join Date
    08-14-2016
    Location
    Dubai
    MS-Off Ver
    2013
    Posts
    11

    Re: Multi Column List Box (14) in user form not working

    could u please edit my code to suit the requirement please

  6. #6
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    7,151

    Re: Multi Column List Box (14) in user form not working

    Try this:

    Please Login or Register  to view this content.

  7. #7
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: Multi Column List Box (14) in user form not working

    Hi,
    I made an example without the unnecessary code of your example.
    It is a zip file, unpack first.
    You will find the file an a folder named Images.
    In the folder, you will find 2 images 2471 & 2471B (B from big)
    To test the images, click on the first record of your table Umar Mukamdam with Emp No 2471.
    So for all the employees, name the pictures as the EmpNo. and for the big picture EmpNo. +B
    The fields that where mandatory in your example are also mandatory in this example.
    I used a real table for the master list, If you add a record,all the properties are the same as de row above
    (formula in column Validity)
    See attached.
    Have fun.
    Attached Files Attached Files
    Click the * Add Reputation below to say thanks.

  8. #8
    Registered User
    Join Date
    08-14-2016
    Location
    Dubai
    MS-Off Ver
    2013
    Posts
    11

    Re: Multi Column List Box (14) in user form not working

    HI Man.
    "dotchiejack"

    Thanks for your Help , I don't have words to express that how much u work help me. I was Relay stuck and my mind was empty.

    Once again thank you so much Bro..... You make my day!

  9. #9
    Registered User
    Join Date
    08-14-2016
    Location
    Dubai
    MS-Off Ver
    2013
    Posts
    11

    Re: Multi Column List Box (14) in user form not working

    Quote Originally Posted by rorya View Post
    Try this:
    Your Code is amazing it’s solve my problem with ease. Thank you so much!
    !! God bless you!!
    I am gleeful with you code….. I was in bad stuck and your code work like a magic.
    Truly Sir it’s just Awesome and I am obliged!!

    Pradip
    Last edited by AliGW; 02-03-2019 at 05:04 AM.

  10. #10
    Registered User
    Join Date
    08-14-2016
    Location
    Dubai
    MS-Off Ver
    2013
    Posts
    11

    Re: Multi Column List Box (14) in user form not working

    Quote Originally Posted by dotchiejack View Post
    Hi,
    I made an example without the unnecessary code of your example.
    HI Man.
    "dotchiejack"

    Thanks for your Help , I don't have words to express that how much u work help me. I was Relay stuck and my mind was empty.

    Once again thank you so much Bro..... You make my day!
    Last edited by AliGW; 02-03-2019 at 05:04 AM.

  11. #11
    Registered User
    Join Date
    08-14-2016
    Location
    Dubai
    MS-Off Ver
    2013
    Posts
    11

    Re: Multi Column List Box (14) in user form not working

    Could I get one more help from you, Can I add one print button on this user form what u made for me to print ID card from “Image folder “directly. And it has to be work on 32 & 64 bit system.
    Kindly…… Please
    Last edited by AliGW; 02-03-2019 at 05:03 AM.

  12. #12
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: Multi Column List Box (14) in user form not working

    on 32 & 64 bit system
    It works on 32 & 64 system.
    If you mean office 32 & office 64,I can't help you, I only have office 32.
    See attached: userform2 with printbutton.
    Attached Files Attached Files

  13. #13
    Registered User
    Join Date
    08-14-2016
    Location
    Dubai
    MS-Off Ver
    2013
    Posts
    11

    Re: Multi Column List Box (14) in user form not working

    Hi, its work fine in even 64 bit thanks to guide me.
    So nice of you.

    I need one more help.... In “Welder Master File" I want to change Mandatory Field to CT-1,CT-02,CT-03,CT-05 & CT-6 only.
    I attached my file I change it little bit to suit my needs.

    Welder Master2 - Copy.xlsm
    Last edited by AliGW; 02-03-2019 at 05:04 AM.

  14. #14
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    59,374

    Re: Multi Column List Box (14) in user form not working

    Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

    For normal conversational replies, try using the QUICK REPLY box below.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  15. #15
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: Multi Column List Box (14) in user form not working

    With Mandatory Fields changed
    Attached Files Attached Files

  16. #16
    Registered User
    Join Date
    08-14-2016
    Location
    Dubai
    MS-Off Ver
    2013
    Posts
    11

    Re: Multi Column List Box (14) in user form not working

    Hi I am getting error after Mandatory field change " RUN TIME ERROR: 13 Type Mismatch.

    1.JPG2.JPG

  17. #17
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: Multi Column List Box (14) in user form not working

    That is because you didn't fill CT_10.Value (Expiry Date)
    Change CDate(CT_10.Value)to CT_10.Value in Private Sub Cmd_01_Click()
    Check if the date format is correct.

  18. #18
    Registered User
    Join Date
    08-14-2016
    Location
    Dubai
    MS-Off Ver
    2013
    Posts
    11

    Re: Multi Column List Box (14) in user form not working

    Quote Originally Posted by dotchiejack View Post
    With Mandatory Fields changed

    Hi After Mandatory Fields changed following error are appearing
    1.JPG
    2.JPG
    3.JPG4.JPG

  19. #19
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: Multi Column List Box (14) in user form not working

    Look at post #17

  20. #20
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: Multi Column List Box (14) in user form not working

    The last error is because of the formula.

  21. #21
    Registered User
    Join Date
    08-14-2016
    Location
    Dubai
    MS-Off Ver
    2013
    Posts
    11

    Re: Multi Column List Box (14) in user form not working

    hello dotchiejack,

    Thanks for your all the guidance.
    Still My I problem is not solved

    On the same file when ever I am clicking on list box in row where column #5 value is text I am getting this error.

    Error Image and file attached.
    Kindly guide me ...Please


    1.JPG
    3.JPG
    2.JPGWelder Master_ Final.xlsm

  22. #22
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: Multi Column List Box (14) in user form not working

    This last error is because of the formula in column 14.
    Delete de formula of nr 37 (like picture above) and then click in the listbox,you will not get the error.

+ 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. How user Form can be accessed by multi user in online?
    By bala04msw in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-20-2018, 09:47 PM
  2. Multi-column dropdown list using multi-column dynamic range (no VBA)
    By ysdai7287 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-04-2018, 03:59 AM
  3. Multi User Login Form - Help
    By tfilipe in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-22-2018, 07:26 PM
  4. Populate a column from a user form list box
    By Mister P in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-19-2011, 07:53 PM
  5. Multi List Box in User Form
    By zimbo109 in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 05-02-2010, 04:08 AM
  6. Create a user form with a multi-column list box
    By duugg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-13-2009, 11:33 PM
  7. how do i set up multi page user form
    By Davidrowland88 in forum Excel General
    Replies: 1
    Last Post: 03-03-2005, 04:06 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1