You can make the cell look empty in the worksheet (not in the formula bar).

You could use the same font color as fill color (white on white) or use a custom
format of:
;;;
(3 semicolons)

me.range("b41,b45").numberformat = ";;;"
and to see it:
me.range("b41,b45").numberformat = "General"


Sara wrote:

Thanks Dave. That works perfectly.

I also want to tie the same checkbox (checkbox3) to hide the values in cell
B41 and B45 if it is checked. Is their a way to just hide the cell text
rather than hidding the entire row or a column? I am not sure how to write
the code for a specific cell.

--

Dave Peterson