VBA Code Help

  • Thread starter Thread starter Dazza
  • Start date Start date
D

Dazza

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
 
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?
Click to expand...
= 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."
Click to expand...
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."
Click to expand...

= C33 + 50
 
Back
Top