+ Reply to Thread
Results 1 to 21 of 21

Listbox several rows ID

  1. #1
    Forum Contributor
    Join Date
    09-28-2019
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    147

    Listbox several rows ID

    Hello,
    I would like to have a listbox to have my budgets (although each budget can have Max 5 products (each with a lot of extras) which is better to have 5 rows (otherwise all in one row i would have around 250 columns

    If i dblclick on listbox ID 10 for example can i get values from first row, 2nd, 3rd, 4th and 5th? Or i can only get the values from the row i click? Is there a way to do like offset?

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Listbox several rows ID

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Forum Contributor
    Join Date
    09-28-2019
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    147
    Quote Originally Posted by Pepe Le Mokko View Post
    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    What i need is in a userform i cannot demonstrate

    Dblclick 1st row, copy data from first 5 rows and paste on textboxs

  4. #4
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Listbox several rows ID

    Mock up some data in a sheet to enable us to see what format/structure you are proposing as data storage from there we will be able to help.

  5. #5
    Forum Contributor
    Join Date
    09-28-2019
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    147

    Re: Listbox several rows ID

    Quote Originally Posted by torachan View Post
    Mock up some data in a sheet to enable us to see what format/structure you are proposing as data storage from there we will be able to help.
    Please use:
    USERNAME: TESTE
    PASSWORD: TESTE

    Go to:
    Worksheet INTERFACE ---> THEN "GESTÃO ORÇAMENTOS"

    Right now you can see:
    5 options(1st is EXTRA, 2nd is SUPER, 3RD, 4H AND 5TH ARE EMPTY)

    I want when i click on "CÁLCULO ORÇAMENTO TAPASOIS" it saves all that on a worksheet to be able to call for that budget and edit it.

    When i click "MOSTRAR ORÇAMENTOS FILTRADOS" That should fill the Listbox with the database and when i click on the budget ROW, it refill all the textbox's again

    I have this being done on INTERFACE -> "GESTÃO CLIENTES" but that's for only ONE row (5 options i don't know how do it, i don't want 250columns)

    Hope you guys can help me out

    Thanks in advance
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    09-28-2019
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    147

    Re: Listbox several rows ID

    i can use something like this on DblClick
    Please Login or Register  to view this content.
    Use i row then put the 4 on bottom of that.

    Hopefully you can give me a better way cuz this will result on mistakes later cuz can jump an ID, Needs to search for ID then 1st row, then ID 2nd row

    Please tell me if you can understand by my file and what i wrote

    Thanks

  7. #7
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Listbox several rows ID

    Sorry cannot help as the VBA is password protected, need to see the code.

  8. #8
    Forum Contributor
    Join Date
    09-28-2019
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    147

    Re: Listbox several rows ID

    Quote Originally Posted by torachan View Post
    Sorry cannot help as the VBA is password protected, need to see the code.
    ahah , sorry, forgot that one
    password: teste

    Please use this new file
    Attached Files Attached Files

  9. #9
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Listbox several rows ID

    Administrative Note:

    Please don't quote entire posts unnecessarily. They are just clutter and make threads hard to read.
    Use the "Quick reply" instead
    Thanks

  10. #10
    Forum Contributor
    Join Date
    09-28-2019
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    147

    Re: Listbox several rows ID

    Ok thank you for advice

    can you help me with the file?

  11. #11
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Listbox several rows ID

    Still trying to get my head around what you are attempting.
    torachan

  12. #12
    Forum Contributor
    Join Date
    09-28-2019
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    147
    Thank you very much torachan!

    I have that made for 1 entry, for 5 option i can put every thing on Same row, but that Will BE like 250columns. It was the Best if i can have it as 5 rows.

    I Will need to create budget and then edit it, in that case i need to have that without errors

    Any question let me Know

    Thanks

  13. #13
    Forum Contributor
    Join Date
    09-28-2019
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    147

    Re: Listbox several rows ID

    Hello guys

    Any hint on how to do it?
    Thanks

  14. #14
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Listbox several rows ID

    Really struggling with this one 'cannot see the wood for the trees'
    Help ! anybody ?

  15. #15
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Listbox several rows ID

    Administrative Note:

    We don't expect you to bump threads more than once in 24 hours - it has been only 4 hours since you posted your last bump. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

  16. #16
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Listbox several rows ID

    ????????????????????????????????????
    @ Pepe Toooooooo quick of the mark today !
    Surely we are allowed to reply in less than 24 hours
    torachan.

  17. #17
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Listbox several rows ID

    Your reply looks more like "bumping" to me

  18. #18
    Forum Contributor
    Join Date
    09-28-2019
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    147
    Hello pepee,

    I havent bumped any time

    About this question seems like no one has any hint on how to do it i am stuck

  19. #19
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Listbox several rows ID

    OK , forget about the " bumping" post.

  20. #20
    Forum Contributor
    Join Date
    09-28-2019
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    147

    Re: Listbox several rows ID

    Hello all

    Do anyone has some hint or solution for my problem?
    Get back to me asap

  21. #21
    Forum Contributor
    Join Date
    09-28-2019
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    147

    Re: Listbox several rows ID

    No one can help me out on my need? Should i close my case then?

+ 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. [SOLVED] VBA to search table for number and populate listbox with all rows with a total of the rows
    By rahul_ferns76 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-08-2019, 01:38 AM
  2. Rows in Listbox to rows in Excel (Range)
    By Littlefarmer in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-17-2015, 05:50 AM
  3. [SOLVED] if anything in listbox select first item, if listbox empty do nothing (listbox in userform
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2015, 12:49 PM
  4. highlight rows in listbox
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-07-2014, 12:06 PM
  5. Listbox to Listbox, no duplicates & submitting same UserForm data for each Listbox entry.
    By jamieswift1977 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-18-2012, 12:18 PM
  6. Read text file to ListBox and Delete rows in ListBox and re-write text file
    By Nu2Java in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-29-2012, 09:42 AM
  7. Find the rows in excelsheet and pop up listbox with those rows
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-09-2010, 12:11 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