I have placed an Active X textbox on my macro-enabled Excel worksheet. I want to add code to the control.
How do I get the textbox to display the following text: "Test of code was successful."
if the value in cell A1 minus the value in cell B1 is greater than 0?
So, for example if the value in cell A1 is 2 and the value in B1 is 1, the message should display. Otherwise, the textbox should remain empty/blank.