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
This will call my Sub updateTextBoxes() I have set up from Textbox2 to textbox10
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
Bookmarks