+ Reply to Thread
Results 1 to 2 of 2

USERFORM insert data in range

  1. #1
    Registered User
    Join Date
    11-14-2019
    Location
    US
    MS-Off Ver
    Office 10
    Posts
    26

    USERFORM insert data in range

    Greetings all,

    I am currently working on a userform with multiple check boxes, what i am trying to accomplish is once the user selects there check boxes, the data is inserted to rows. I have created a subform and checkboxes. But the problem i am having is I can only select one checkbox. Below is the code I understand this is probably basic to some but i am new to using VBA and would really love to learn more.

    Prolem 2.PNG


    Please Login or Register  to view this content.
    Last edited by Pepe Le Mokko; 11-21-2019 at 10:50 AM.

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,135

    Re: USERFORM insert data in range

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    I did it for you this time. Please read forum rules. Thanks
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

+ 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. Insert data from userform
    By neilsy1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-18-2016, 07:56 PM
  2. Insert New Row with Data from Userform
    By stephenanderson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2016, 08:25 PM
  3. How can I create a mask (Userform) to insert data?
    By balsilo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2013, 04:16 PM
  4. Replies: 1
    Last Post: 09-05-2012, 04:11 PM
  5. How to insert a dynamic range in a UserForm into a ListBox
    By stojko89 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-18-2011, 03:28 AM
  6. Userform insert data on the last row even when autofilter is active
    By jpruffle in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-29-2009, 02:24 PM
  7. Insert UserForm Data in Named Range
    By Patchworks in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-15-2009, 10:50 PM

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