Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) | |||
VBA code delete code but ask for password and unlock VBA protection | Excel Programming |