I would like to set the default value to be false, does anyone have any
suggestions on how to do it in Excel?
Thanks in advance for any suggestions
Eric

Public endChange As Boolean

The default value for a Boolean is False when it is declared. No problem -
it's already done for you.

Want proof? Put this code right below it and run it repeatedly using F5:
Sub TestEndChange()
MsgBox "endChange is " & endChange
endChange = Not endChange
End Sub

First time you run it, you'll see it is False. After that, it toggles
between True and False.


"Eric" wrote:

> I would like to set the default value to be false, does anyone have any
> suggestions on how to do it in Excel?
> Thanks in advance for any suggestions
> Eric
>
> Public endChange As Boolean

endChange = False


"Eric" <(E-Mail Removed)> wrote in message
news:5D8081B7-EF7B-4181-B582-(E-Mail Removed)...
>I would like to set the default value to be false, does anyone have any
> suggestions on how to do it in Excel?
> Thanks in advance for any suggestions
> Eric
>
> Public endChange As Boolean