+ Reply to Thread
Results 1 to 3 of 3

Copy all Entries from Form Control (not ActiveX) List Box to Worksheet

  1. #1
    Registered User
    Join Date
    12-27-2011
    Location
    Unknown
    MS-Off Ver
    Excel 2010
    Posts
    7

    Copy all Entries from Form Control (not ActiveX) List Box to Worksheet

    Hi Everyone,

    I am trying to copy all the entries from Form Control (not ActiveX) List Box without any success.

    The code, that I used to create the list boxes is given below:

    Please Login or Register  to view this content.
    Later (after populating the List Box), I need to copy all the entries from a concrete List Box : V1 - to worksheet cells; V2 - would like to populate check boxes according to the values copied.

    Any help would be highly appreciated.
    Last edited by Saramara; 02-08-2012 at 07:59 AM.

  2. #2
    Registered User
    Join Date
    12-27-2011
    Location
    Unknown
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Copy all Entries from Form Control (not ActiveX) List Box to Worksheet

    Hello once again,

    Any ideas how to solve the problem?

    Thank in advance.

  3. #3
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Copy all Entries from Form Control (not ActiveX) List Box to Worksheet

    Perhaps you need to upload a workbook with what you want (check boxes, list boxes, and the likes) and what you want them to do. Otherwise, people here will always be guessing, which is probably why you haven't had a response yet from the fine helping members of this forum. The workbook you upload should contain no personal information in it but there should be data in it according to your requirements.

    To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'.
    To use the main 'New Post' page, click the 'Post Reply' button in the relevant thread.

    On this page, below the message box, you will find a button labelled 'Manage Attachments'.
    Clicking this button will open a new window for uploading attachments.

    You can upload an attachment either from your computer or from another URL by using the appropriate box on this page.
    Alternatively you can click the Attachment Icon to open this page.

    To upload a file from your computer, click the 'Browse' button and locate the file.

    To upload a file from another URL, enter the full URL for the file in the second box on this page.
    Once you have completed one of the boxes, click 'Upload'.

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

+ 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