+ Reply to Thread
Results 1 to 5 of 5

Make Worksheet Active-X CheckBox value same as Userform CheckBox value

  1. #1
    Forum Contributor
    Join Date
    10-08-2013
    Location
    London
    MS-Off Ver
    365
    Posts
    129

    Make Worksheet Active-X CheckBox value same as Userform CheckBox value

    Hi All,

    I am trying to finish off code for an 'Add Data' userform button that will check some active-x checkboxes in the active worksheet if the corresponding userform checkboxes have been checked. I have tried many different permutations of the code to get this to work (endless google searches) and am getting nowhere. The userform checkboxes and worksheet active-x checkboxes are all correspondingly numbered 1 to 6 so I used a simple loop to check or uncheck each checkbox. The code in its present state is below.
    Please Login or Register  to view this content.
    If someone could assist with the correct terms and syntax I would be most grateful.

    Kind regards,
    Last edited by L plates; 04-21-2016 at 07:11 AM. Reason: Title & Code error!
    Dave C

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,137

    Re: Make Worksheet Active-X CheckBox value same as Userform CheckBox value

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).
    My Rules if you want my help:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Forum Contributor
    Join Date
    10-08-2013
    Location
    London
    MS-Off Ver
    365
    Posts
    129

    Re: Make Worksheet Active-X CheckBox value same as Userform CheckBox value

    First an apology - I have corrected my first error in my original code above by changing the Me.Control line from ComboBox to Checkbox.
    Secondly, I have attached an example file. When you click the 'Change Data' button the UserForm is shown. The check boxes checked in the userform should be mirrored on the worksheet when the 'Add Data To Worksheet' button is clicked.

    Thanks again,
    Attached Files Attached Files
    Last edited by L plates; 04-21-2016 at 07:32 AM. Reason: punctuation and code above, not below

  4. #4
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,137

    Re: Make Worksheet Active-X CheckBox value same as Userform CheckBox value

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    10-08-2013
    Location
    London
    MS-Off Ver
    365
    Posts
    129

    Re: Make Worksheet Active-X CheckBox value same as Userform CheckBox value

    Many thanks for the solution mehmetcik and very much appreciated! OLEObjects was where it was at!

+ 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. [SOLVED] userform to refer to active X check boxes in excel
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-31-2015, 01:10 PM
  2. How to make an active check box larger?
    By JET2011 in forum Excel General
    Replies: 7
    Last Post: 09-23-2015, 07:33 PM
  3. Active X Checkbox Linkage - in worksheet
    By umeshbanga in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-11-2015, 03:51 PM
  4. make a userform check box and password
    By jekidi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-23-2014, 12:34 AM
  5. Userform linking with active worksheet not maintaining link with correct worksheet
    By millerj64 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-29-2012, 09:47 AM
  6. Replies: 6
    Last Post: 08-06-2012, 10:53 AM
  7. Check URL in Worksheet if Active
    By ryanb4614 in forum Excel General
    Replies: 0
    Last Post: 04-06-2011, 11:15 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