+ Reply to Thread
Results 1 to 3 of 3

Checkbox Adding Value To a Textbox

  1. #1
    Registered User
    Join Date
    06-05-2014
    Posts
    28

    Checkbox Adding Value To a Textbox

    Have a userform with a checkbox and whenever i check it off, the value of a textbox goes from 19 to zero.

    I created another textbox48 and I want to place an 'F' in it whenever that same checkbox is checked off. below is the code

    Please Login or Register  to view this content.
    Private Sub cbxna40_Click()
    If cbxna40 Then
    txtpossible40.Value = 0
    txtscore40.Value = 0
    Else

    txtpossible40.Value = 19
    txtscore40.Value = 19

    End If
    End Sub
    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Checkbox Adding Value To a Textbox

    Just add this.
    Please Login or Register  to view this content.
    PS Can you add code tags when posting code?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    06-05-2014
    Posts
    28

    Re: Checkbox Adding Value To a Textbox

    thanks, taht worked. thought i did place tags? next time for sure

+ 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. Recommended Events on Checkbox/TextBox
    By excelenergy in forum Excel General
    Replies: 1
    Last Post: 03-10-2014, 12:12 PM
  2. Userform Textbox to activate checkbox when at bottom.
    By ourgarden in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-06-2013, 08:03 PM
  3. [SOLVED] textbox and checkbox
    By ngkj in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 07-12-2012, 04:21 AM
  4. Replies: 5
    Last Post: 11-18-2010, 05:37 PM
  5. Use checkbox to allow textbox input
    By JamesT1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2010, 01:54 AM

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