+ Reply to Thread
Results 1 to 4 of 4

Make certain Textbox negative value based on CheckBox

  1. #1
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Make certain Textbox negative value based on CheckBox

    Good day,
    I have a part of code but would need to see if there is a simple way to combine all my textbox to become negative value If my Combobox is checked.


    In my Module, This will Calculate my Textbox11 each time I call for my Sub
    Please Login or Register  to view this content.
    This will call my Sub updateTextBoxes() I have set up from Textbox2 to textbox10
    Please Login or Register  to view this content.
    In my Userform I have a CheckBox1. If this CheckBox1 is Selected then I need to change the entry of all Textboxes(2-10) to be negative Value.

    Works well right now but I need to identify all Textbox separately how could I bundle this up... even if a module is called...

    So IF checkbox1 = True then textbox2 to textbox10 will = a negative value... If user adds 2 to textbox2 when the checkbox1 is = True then 2 will turn to -2

  2. #2
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Re: Make certain Textbox negative value based on CheckBox

    Instead of:

    Please Login or Register  to view this content.
    Or is this the best result?

  3. #3
    Forum Contributor
    Join Date
    03-29-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    818

    Re: Make certain Textbox negative value based on CheckBox

    I will going to this solution:

    Module:
    Please Login or Register  to view this content.

    UserForm:
    Please Login or Register  to view this content.


    If there would be a shorter code then please feel free... Thank you for all that was looking

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

    Re: Make certain Textbox negative value based on CheckBox

    This is slightly shorter.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

+ 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. help to convert textbox value to negative based on another textbox value
    By lewisw in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 03-19-2014, 11:00 AM
  2. Recommended Events on Checkbox/TextBox
    By excelenergy in forum Excel General
    Replies: 1
    Last Post: 03-10-2014, 12:12 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. Use checkbox to allow textbox input
    By JamesT1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2010, 01:54 AM
  5. Replies: 5
    Last Post: 05-12-2009, 04:47 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