+ Reply to Thread
Results 1 to 4 of 4

CheckBox in Userform

  1. #1
    Registered User
    Join Date
    03-12-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2003
    Posts
    55

    CheckBox in Userform

    Dear all,

    Can you please guide me, how to update the same date into another sheet when i select the checkbox . the Following code i am using to save data.
    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,177

    Re: CheckBox in Userform

    if chkBox.value then sheets("sheet2").range("b1").value = me.txtDate

  3. #3
    Registered User
    Join Date
    03-12-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2003
    Posts
    55

    Re: CheckBox in Userform

    Will you be able to fix this in to my code ?
    Checkbox name = CheckBox1
    I want the data in Sheet6
    The Following data should be capture in "Sheet6" when in click on the cmdAdd Button
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    03-12-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2003
    Posts
    55

    Re: CheckBox in Userform

    Any Help ?

+ 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] Make Worksheet Active-X CheckBox value same as Userform CheckBox value
    By L plates in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-21-2016, 08:23 AM
  2. [SOLVED] Checkbox problem on userform
    By Villalobos in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-31-2014, 08:02 PM
  3. [SOLVED] Userform - checkbox
    By Lukael in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2014, 01:49 PM
  4. Get UserForm checkbox caption and pass to another UserForm on click or mouse down
    By tulsaguy71 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-08-2013, 11:07 AM
  5. UserForm and CheckBox
    By zplugger in forum Excel General
    Replies: 4
    Last Post: 12-05-2011, 10:39 AM
  6. Userform Checkbox
    By Bill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-20-2006, 05:15 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