+ Reply to Thread
Results 1 to 7 of 7

Form w/ Textbox/Radio buttons/Checkbox and button to transfer to 2nd sheet as database

  1. #1
    Registered User
    Join Date
    06-22-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    32

    Form w/ Textbox/Radio buttons/Checkbox and button to transfer to 2nd sheet as database

    Hello everyone, I need help in the file that I have attached, basically just entering data then how to put the entered and selected data to the next sheet.
    Thank you in advance.
    Attached Files Attached Files
    Last edited by christlivethinme; 01-26-2013 at 06:54 PM.

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Form w/ Textbox/Radio buttons/Checkbox and button to transfer to 2nd sheet as database

    Hi christlivethinme

    Try the Code in the attached...let me know of issues.
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #3
    Registered User
    Join Date
    06-22-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    32

    Re: Form w/ Textbox/Radio buttons/Checkbox and button to transfer to 2nd sheet as database

    Quote Originally Posted by jaslake View Post
    Hi christlivethinme

    Try the Code in the attached...let me know of issues.
    Hi, it worked however the problem is the user should be able to select multiple checkbox items and then concatenate it when transferred in the next sheet.

  4. #4
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Form w/ Textbox/Radio buttons/Checkbox and button to transfer to 2nd sheet as database

    Geez christlivethinme...it took me a couple hours to sort out how to do this and make it NOT happen
    the problem is the user should be able to select multiple checkbox items
    OH well...I'll fix it.

  5. #5
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Form w/ Textbox/Radio buttons/Checkbox and button to transfer to 2nd sheet as database

    Hi christlivethinme

    Try the attached...changed for this
    the user should be able to select multiple checkbox items
    Attached Files Attached Files
    Last edited by jaslake; 01-26-2013 at 12:11 PM. Reason: Modified Code in event of empty array

  6. #6
    Registered User
    Join Date
    06-22-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    32

    Re: Form w/ Textbox/Radio buttons/Checkbox and button to transfer to 2nd sheet as database

    Great! thank you so much!

  7. #7
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Form w/ Textbox/Radio buttons/Checkbox and button to transfer to 2nd sheet as database

    You're welcome...glad I could help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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