+ Reply to Thread
Results 1 to 3 of 3

Get a UserForm CheckBox to show a "1" in a cell when checked.

  1. #1
    Registered User
    Join Date
    04-23-2019
    Location
    Pittsburgh, PA
    MS-Off Ver
    MS Office 365
    Posts
    7

    Question Get a UserForm CheckBox to show a "1" in a cell when checked.

    Good morning!

    I've created a Data Entry form with a form checkbox.

    The table cell in which the data will be entered for this checkbox has formatting to generate a wingding check mark when the number "1" is entered into it. I want to get the checkbox to report as "1" or "" for the traditional True or False entries so that the check mark will show in the table when the box is checked, and remains blank when not checked.

    The code I'm using was copied from another site, and I'm trying to make it work for my needs, but I'm not skilled at this yet and am not sure how to attack it.

    I'm hoping you can help me change this code to operate as such. I'll attach screenshots to hopefully better illustrate what I'm looking to do.

    Capture.PNG

    Capture1.PNG

    Thanks!

    Please Login or Register  to view this content.

  2. #2
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: Get a UserForm CheckBox to show a "1" in a cell when checked.

    Please Login or Register  to view this content.

  3. #3
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: Get a UserForm CheckBox to show a "1" in a cell when checked.

    Don't use AddItem to fill listboxes, it's a very slow method.
    Use lists.
    I rewrote your code.
    That is all you need.
    Please Login or Register  to view this content.
    See attached.
    Click the * Add Reputation below to say thanks.

+ 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 checkbox - need to return "Yes" or "No" to worksheet
    By Sparkytech in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-05-2018, 06:39 PM
  2. VBA Updates Pivot Table by cell contents, i want to show "blank" instead of "all"
    By mattinwpg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-15-2017, 10:58 PM
  3. Replies: 1
    Last Post: 09-24-2015, 11:50 AM
  4. [SOLVED] UserForm CheckBox to output "Yes" instead of "True"
    By DomSza in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-07-2015, 10:30 AM
  5. If "6343" in cell A3 matches "monthly" in B3 show a "Y" in C3
    By laaxy in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 04-05-2014, 07:38 PM
  6. [SOLVED] At least one checkbox must be checked - "OLEObjects error"
    By henryBukowski in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 08-19-2013, 09:25 AM
  7. Replies: 9
    Last Post: 11-06-2012, 08:59 AM

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