+ Reply to Thread
Results 1 to 4 of 4

Filling values in text box when Checkbox is unchecked

  1. #1
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Filling values in text box when Checkbox is unchecked

    • I have a Checkbox in a Frame
    • I already have a macro to fill three text boxes when this checkbox value is true (i.e when checkbox is checked)
    • But I want the same three text boxes to be filled with some other values when the Check box value is false ( i.e when the check mark is removed from the checkbox)
    • Is there a way to do it?

    Any help is much appreciated

    Thanks
    Last edited by subbby; 07-01-2016 at 08:33 AM. Reason: Solved

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,858

    Re: Filling values in text box when Checkbox is unchecked

    Here is a link to help you. While they have only updated one cell, you can amend to update more.

    http://www.excel-easy.com/vba/examples/check-box.html

    http://stackoverflow.com/questions/1...excel-vba-2010
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Re: Filling values in text box when Checkbox is unchecked

    Thank you for responding back. Appreciate it.

    But in all these examples, the check box is used in a code.

    What I need is like an _Afterupdate , _ Change scenario. That is, the moment the checkbox is unchecked, it should input values in three textboxes. For example , please see the following code. It is an example where when the user selects the checkbox, it automatically deletes values from those three text boxes

    Please Login or Register  to view this content.
    Is is there any unclick function ?

  4. #4
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Re: Filling values in text box when Checkbox is unchecked

    Hi,

    I tried the following and it does what I wanted


    Please Login or Register  to view this content.
    Thanks for trying .

    -Subbby

+ 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. Grey shading to row when checkbox unchecked
    By Allycat84 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-13-2015, 09:34 PM
  2. [SOLVED] Remove data when checkbox is unchecked
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-23-2013, 10:13 PM
  3. Checkbox When Unchecked Hides Worksheet
    By dcarn in forum Excel General
    Replies: 1
    Last Post: 12-06-2012, 06:57 PM
  4. [SOLVED] How do I change a checkbox to unchecked without running the code within the checkbox
    By jsunnb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-27-2012, 09:28 PM
  5. [SOLVED] ActiveX Checkbox entering a value when checked or unchecked
    By Sky188 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-18-2012, 02:59 PM
  6. Unchecked listbox using checkbox OLEObject
    By emina002 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-18-2012, 11:49 PM
  7. calculate checked and unchecked of checkbox
    By laici in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-03-2009, 02:12 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