Formula using VBA?

[Rana Gray]

Hey Everyone,

Sorry for the silly question but can someone help me with the VBA version of this formula: =IF($E13=TRUE,$B13,"")

Basically I don't want to put the formula directly in the cell where it can be overwritten, I also need it to apply to all rows (columns are fixed). All this does is if my checkbox is ticked the date in cell E13 gets copied into cell N13 etc. if it's not ticked then leave blank.

Thank you in advance!!

 

[Rana Gray]

Okay, I have tried and tried to get this to work, and I just can't. The only thing I managed to get working was the original code I provided, but I had to trigger it manually. Worksheet_Change was not working, and other code that ran just fine on my test sheet didn't want to even start. You will probably be best served using your CheckBox_Click codes if those are doing what you want.

thank you so much for all the time you put into this I really do appreciate you! <3

 

[dreid1011]

You're welcome.