What I would do is make the routine on the checkbox change the value in
a third "container" cell for instance "J7" (or any unused cell in your
workbook) to true/false when it's checked/unchecked.

Then just set the conditional formating of your cell "C9" to whatever
you want based on the true/false indicator in "J7".

You want to include some code on your from under
frmLeaveRequest_Activate to check the value of "J7" and check/uncheck
the box accordingly when you bring the form back up.

This is all assuming you want to keep that formating once the userform
is deactivated.


cedtech23 wrote:
I have a userform called frmLeaveRequest that contains a check box named
chkVac, I want to pass the conditional formatting of Bold, Red Font and
a Border around the contents in Cell C9 in an Execl doc called
LRForm.xls in worksheet LeaveRequested when chkVac equals true. How do
I accomplish a task like that??


--
cedtech23
------------------------------------------------------------------------
cedtech23's Profile: http://www.excelforum.com/member.php...o&userid=31022
View this thread: http://www.excelforum.com/showthread...hreadid=563127