+ Reply to Thread
Results 1 to 3 of 3

VBA: transfer values of textboxes & items from listbox to worksheet

  1. #1
    Registered User
    Join Date
    01-15-2013
    Location
    Dubai, UAE
    MS-Off Ver
    Excel 2010
    Posts
    57

    Post VBA: transfer values of textboxes & items from listbox to worksheet

    Hello!

    I'm hoping anyone could assist me in my problem.
    I have a listbox & command button in a userform. When I click the button, all items selected in listbox will be transferred in "A" column of worksheet on the next empty cell.

    What I need is to transfer the rest of the details in the userform (textboxes & labels) to its designated rows & columns where the first item (from listbox) is located. With the code I have, the details of the textboxes/labels appeared in the row/column of the "last item" and not on the first.

    Your ideas will be highly appreciated. Thanks!!

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    01-15-2013
    Location
    Dubai, UAE
    MS-Off Ver
    Excel 2010
    Posts
    57

    Re: VBA: transfer values of textboxes & items from listbox to worksheet

    Can anyone please tell me how I can at least make the values of textbox and labels appear in every rows of each item I selected in list box?

    Or is this even possible since I really can't find a way to code my first option

    Thanks much!!

    hydz1213

  3. #3
    Registered User
    Join Date
    01-15-2013
    Location
    Dubai, UAE
    MS-Off Ver
    Excel 2010
    Posts
    57

    Post Re: VBA: transfer values of textboxes & items from listbox to worksheet

    Am just glad to solve this problem. The answer is just under my nose It's just really obvious that I'm a newbie in vba :D

    Anyway, just for the sake of other people having same scenario, I was able to put details of users to worksheet for each items selected in a listbox.

    Here's the code:

    Please Login or Register  to view this content.
    Last edited by hydz1213; 02-19-2013 at 06:09 AM.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1