Is Excel is now going out of it's way to mess me around?

How come this works?

if I place this formula in a cell

=IF(A1 <> "",ResetFont())


And in Module1 the Subroutine is

Sub ResetFont()
msgBox(ActiveCell.Value)
End sub


BUT this doesnt?

Sub ResetFont()
ActiveCell.Font.Size = 10
End sub


Also if I try

Sub ResetFont()
ActiveCell.Value = "1"
End sub

It throws an error in the cell with the =IF(...?

The first one works because the Sub doesn't attempt to change any
property of Excel.


"Willot" <Willot.29230y_1149723901.9727@excelforum-nospam.com>
wrote in message
news:Willot.29230y_1149723901.9727@excelforum-nospam.com...
>
> HOW COME THIS WORKS?
> if I place this formula in a cell
>
> =IF(A1 <> "",ResetFont())
>
>
> And in Module1 the Subroutine is
>
> Sub ResetFont()
> msgBox(ActiveCell.Value)
> End sub
>
>
> BUT THIS DOESNT?
> Sub ResetFont()
> ActiveCell.Font.Size = 10
> End sub
>
>
> ALSO IF I TRY
> Sub ResetFont()
> ActiveCell.Value = "1"
> End sub
>
> *It throws an error in the cell with the =IF(...?*
>
>
> --
> Willot
> ------------------------------------------------------------------------
> Willot's Profile:
> http://www.excelforum.com/member.php...o&userid=35166
> View this thread:
> http://www.excelforum.com/showthread...hreadid=549742
>

Yep. I see that. I just dont understand why it has a problem with the fact I want to change a properity of the cell.
Is Excel just having one of it's turns?

Functions called from a worksheet cell cannot change any other
cell. This restriction is so that Excel can maintain its table of
precedent and dependent cells. If VBA functions called from a
worksheet cell were allowed to change cell values, Excel would
have no idea how to calculate the sheet while preserving a valid
table of precedents and dependents. It wouldn't have any idea
what cells the VBA code might change.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Willot" <Willot.29246o_1149725403.148@excelforum-nospam.com>
wrote in message
news:Willot.29246o_1149725403.148@excelforum-nospam.com...
>
> Yep. I see that. I just dont understand why it has a problem
> with the
> fact I want to change a properity of the cell.
> Is Excel just having one of it's turns?
>
>
> --
> Willot
> ------------------------------------------------------------------------
> Willot's Profile:
> http://www.excelforum.com/member.php...o&userid=35166
> View this thread:
> http://www.excelforum.com/showthread...hreadid=549742
>