Results 1 to 2 of 2

Thread: Userform Textboxes values passing to a listbox
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jun 2016
    Posts
    118
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Userform Textboxes values passing to a listbox

    Hello,

    Please I need your help.

    I have the link below for my shop workbook "example workbook" that contains a userform to manage my invoices

    I'm stuck in the following steps and don't know how to solve them, and need your help if you may


    • In TextBox "txtBarCode", If I search for an item by "Barcode Scanner" then run the "txtBarCode Change Event", but in case I need to enter the Barcode manually change the code event to "After Update"



    • Then If the item exist or not (I have a code to lookup the values and put them on TextBoxes, but I need them in the list box)
      • Add the values to ListBox1 that contains 6 columns (Num / Barcode / Item Name / Unit Price / Qty / Amount) as header
        • Row1 Column"Num" = Count the entered rows unless the header
        • Row1 Column"Barcode" = txtBarCode
        • Row1 Column"Qty" = txtQty
        • Row1 Column"Item Name, Unit Price, and Amount" = lookup values reference to the entered Barcode (same code that I have)
        • Next item add to next row...



    • If I need to search by name, I tried the lookup code as on "txtBarCode" with "After Updat Event" but it didn't work
      • I need to check if the entered name is exist or not (the same as on txtBarCode)
      • In case the item exist, lookup the Barcode of this item and put it in txtBarCode



    • On Submit button, add the list box values to sheet2 (check the last empty row)



    Here is the link for the workbook file
    https://drive.google.com/file/d/1mW-...ew?usp=sharing

  2. #2
    Board Regular
    Join Date
    Jun 2016
    Posts
    118
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Userform Textboxes values passing to a listbox

    Any help!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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