Functions used in a worksheet and only return a value to the cell in which
they are used. They can not alter the excel environment. There are a few
exceptions, but nothing along the lines of what you want to do.
So no, it shouldn't work.
--
Regards,
Tom Ogilvy
"Willot" wrote:
If I have a sheet Formula =IF(A1 < "",ChangeSize())
and the ChangeSize() Sub in a VBA module is
Sub ChangeSize()
Msgbox(ActiveCell.value)
ActiveCell.Font.Size = 15
End Sub
It Puts up the Msgbox with the value of A1
But it doesnt change font size in the cell???
--
Willot
------------------------------------------------------------------------
Willot's Profile: http://www.excelforum.com/member.php...o&userid=35166
View this thread: http://www.excelforum.com/showthread...hreadid=549356