VBA Macro to tell a cell to remain blank

**jonvanwyk** · 12-12-2010, 08:15 PM

I cannot use a regular formula because the cell already contains a complicated formula that is doing something else. Can I write some VBA for cell T36 that says something to the affect:

IF T35 IS BLANK, THEN T36 SHOULD ALSO BE BLANK. Ideally, this macro would override any other instructions T36 has.

**teylyn** · 12-12-2010, 08:23 PM

Why can't you do this with the formula you already have in place?

T36 =if(Isblank(T35),"",<your current formula>)

**jonvanwyk** · 12-12-2010, 08:26 PM

Originally Posted by teylyn

Why can't you do this with the formula you already have in place?

T36 =if(Isblank(T35),"",<your current formula>)

Maybe I can....I was not aware of that function. Can you help me insert it? My formula is rediculously long.

Please Login or Register  to view this content.

Thank you in advance if you are able to further assist me. I truly cannot believe how helpful this forum is. If all other Excel resources were to fall off the face of the internet, I think the novice would not be worse off due to excelforum.com!!!

**jonvanwyk** · 12-12-2010, 08:35 PM

Originally Posted by teylyn

Why can't you do this with the formula you already have in place?

T36 =if(Isblank(T35),"",<your current formula>)

Please Login or Register  to view this content.

I believe I correctly inserted your solution, but it did not fix the problem. In this particular instance, if no label is applied to C5, then no math needs to be done, and B6 is referenced. However, when C5 is blank, and B6 is also blank, then T36 is showing 00:00. Please note that the advanced settings already have the box deselected that adds a 0 for blank cells.

Using the above referenced formula, everything is calculated correctly. The problem is when the form is blank and nothing has yet been selected or entered, I have 00:00 all over the place. :-(