VBA Code Help
 

Hi,

I'm trying to automate several manual tasks in a financial
spreadsheet.

1. What code should I use to add 14 days to the whatever
date is currently displayed in cell a2?

2. I need code that will do the following; "If C28 has a
value then the checkbox in the next column is checked else
checkbox is unchecked."

3. I need code that will do the following; "Take the value
in C33 add 50 and place the sum in C27."

Many thanks in advance.
D

VBA Code Help
 

this is probably better done in formulas

-----Original Message-----
Hi,

I'm trying to automate several manual tasks in a
financial
spreadsheet.

1. What code should I use to add 14 days to the whatever
date is currently displayed in cell a2?
= A2 + 14


2. I need code that will do the following; "If C28 has a
value then the checkbox in the next column is checked
else
checkbox is unchecked."

This is in the properties of the checkbox under something
like linked cell

3. I need code that will do the following; "Take the
value
in C33 add 50 and place the sum in C27."


= C33 + 50

Many thanks in advance.
D
.