I'm rather new to Excel and VB, so please bear with me.
In a nutshell I'd like to do the following:
I've got a checkbox in my worksheet. I'd like the contents of a cell to change depending on whether or not that checkbox is ticked or not.
I realize this isn't the proper code, but in "plain english" it would be something like this:
If CheckBox5 = True then K43 = R38-(R38*0.15)
If CheckBox5 = False then K43 = 0
Again, I realize that's not the correct code, but that's what I'd like it to do.
Any help? Thanks.
Bookmarks