+ Reply to Thread
Results 1 to 5 of 5

if one or more checkboxes checked copy userform data to database sheet, one or more times

  1. #1
    Forum Contributor
    Join Date
    08-08-2012
    Location
    englang
    MS-Off Ver
    Excel 2010
    Posts
    152

    if one or more checkboxes checked copy userform data to database sheet, one or more times

    Hi guys,
    I'm new to VBA and i really stuck with my userform.

    I have 16 checkboxes, sometimes people can check one but in other occasions - two,three,four or even all 16 checkboxes can be selected.
    So basicly what i need is when i will press the Update button it will copy all data from userform to DataBase sheet with all checkboxes i selected.
    All checkboxes have different names, so in DataBase sheet column "R" i will see all names of the checkboxes i copied.
    for example if i will check 4 checkboxes that means in DataBase sheet i will see 4 rows with newly copied information, all info will be the same,except column "R" where it should fill the names of the checkboxes.

    Sorry if its not very clear, but i couldnt explain it better.

    I can't provide the original workbook because it is too big and i can't attach it, so I'm attaching the example workbook but you will get an idea whats going on.

    I really appreciate for your help and thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: if one or more checkboxes checked copy userform data to database sheet, one or more t

    Hello intex,

    Here is the updated button code you need.

    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Contributor
    Join Date
    08-08-2012
    Location
    englang
    MS-Off Ver
    Excel 2010
    Posts
    152

    Re: if one or more checkboxes checked copy userform data to database sheet, one or more t

    Hi Leith the code is perfect, but sometimes i need to disable Frame1.
    When the Frame1 is disabled i still would like to copy all values from textboxes to the DataBase

  4. #4
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: if one or more checkboxes checked copy userform data to database sheet, one or more t


  5. #5
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: if one or more checkboxes checked copy userform data to database sheet, one or more t

    Thanks Cytop

    Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

+ 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. How to copy only checked checkboxes into new cell?
    By GTX2013 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-06-2013, 09:06 PM
  2. [SOLVED] Transfer Data from UserForm that their check box had checked!
    By MariaPap in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-06-2013, 01:08 PM
  3. [SOLVED] When checkbox is checked it does not copy to new sheet. Only if not checked using false
    By thelisa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-28-2013, 07:59 AM
  4. [SOLVED] Combining SUMPRODUCT with Checked Checkboxes
    By pstewart in forum Excel General
    Replies: 6
    Last Post: 08-11-2012, 04:49 PM
  5. [SOLVED] My checkboxes will not stay checked.
    By NUMBnut in forum Excel General
    Replies: 0
    Last Post: 01-09-2006, 05:10 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