+ Reply to Thread
Results 1 to 2 of 2

Recommended Events on Checkbox/TextBox

  1. #1
    Forum Contributor
    Join Date
    06-06-2012
    Location
    Toronto, ON
    MS-Off Ver
    Office 365
    Posts
    138

    Recommended Events on Checkbox/TextBox

    I have what might be a simple question. I have a userform that based on user’s answers it calculates a score. Simple right? Well what if a user decides they want to change one of their click boxes – I want their score to recalculate automatically.

    So since the “score” appears in a textbox. Is there an event I can use on the textbox to get it to automatically recalculate based on if a user changes their selection on the checkboxes? Or is it really a textbox issue, maybe I use a different event on the checkboxes?

    Ive tried a change event and an exit event, but those don’t work. Do any of you have any recommendations? I can post the code if need be.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,705

    Re: Recommended Events on Checkbox/TextBox

    If the user is changing checkboxes, you want to use the Change event on every checkbox to cause the recalculation. If the textbox contains the result, it will not be useful to use an event on the textbox.

    What causes the calculation to occur now?

    If you tried a Change event and it doesn't work, you would need to post the code. Ideally you would post your entire file.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Textbox Events
    By puuts in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 04-16-2013, 08:33 AM
  2. [SOLVED] textbox and checkbox
    By ngkj in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 07-12-2012, 04:21 AM
  3. Combining object (textbox and combobox) change events
    By abousetta in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-11-2011, 10:44 PM
  4. User Form TextBox Events
    By max57 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-22-2010, 02:07 PM
  5. Button clicks and textbox Exit events
    By Linc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-26-2005, 07:25 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