Prev: Macro for adding rows if two different columns have a value
Next: Personal Macro Workbook
From: Eric on 12 May 2010 10:51
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
From: JLatham on 12 May 2010 11:00
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
From: JLGWhiz on 12 May 2010 11:29
endChange = False


"Eric" <Eric(a)discussions.microsoft.com> wrote in message
news:5D8081B7-EF7B-4181-B582-35FB0D08D9C6(a)microsoft.com...
>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


 | 
Pages: 1
Prev: Macro for adding rows if two different columns have a value
Next: Personal Macro Workbook