Hello,
I am working on a UserForm in VBA, and I would like to have some type of indicator which is conditionally formatted based on the value of a cell in a workbook (which is derived from a formula).
For example, if the cell value in the workbook is a number > $0.00, show a green highlight, or a green check mark, green textbox, any type of indication that the formula result is valid etc.
if the cell value is either N/A (error) or $0.00, then show a red highlight, or red x, or red textbox, etc.
I've been experimenting with textboxes, labels, and changing the actual userform background color (including initialize, change, click events), and it never seems to work. The formula will start off with a value of $0.00 or N/A, and then as the user changes the combo boxes, the formula will change, and should end with a >$0.00 value (unless the user selects in error). The purpose of this is to let the user know they cannot continue until they select valid combinations from all of the combo boxes on the userform (sorry if this is confusing).
Any suggestions on a path which might achieve my goal?
Thank you in advance!
I am working on a UserForm in VBA, and I would like to have some type of indicator which is conditionally formatted based on the value of a cell in a workbook (which is derived from a formula).
For example, if the cell value in the workbook is a number > $0.00, show a green highlight, or a green check mark, green textbox, any type of indication that the formula result is valid etc.
if the cell value is either N/A (error) or $0.00, then show a red highlight, or red x, or red textbox, etc.
I've been experimenting with textboxes, labels, and changing the actual userform background color (including initialize, change, click events), and it never seems to work. The formula will start off with a value of $0.00 or N/A, and then as the user changes the combo boxes, the formula will change, and should end with a >$0.00 value (unless the user selects in error). The purpose of this is to let the user know they cannot continue until they select valid combinations from all of the combo boxes on the userform (sorry if this is confusing).
Any suggestions on a path which might achieve my goal?
Thank you in advance!