<div>
You can arrange a Constant. When running the Program, Me.Sheet = 1<br />
or any other Value you want.<br />
<br />
Const mSheet = 1<br />
<br />
Public Property Get Sheet() As Long<br />
&nbsp; Sheet = mSheet<br />
End Property<br />
<br />
Private Sub Form_Load()<br />
Caption = Me.Sheet<br />
End Sub
</div>


You can arrange a Constant. When running the Program, Me.Sheet = 1
or any other Value you want.

Const mSheet = 1

Public Property Get Sheet() As Long
  Sheet = mSheet
End Property

Private Sub Form_Load()
Caption = Me.Sheet
End Sub

<div>
Get is a read only property. Do you want to write to &quot;Sheet&quot; ?
</div>


Get is a read only property. Do you want to write to "Sheet" ?

<div>
<div class="content wysiwyg-content">
I am trying to set a default value for &quot;sheet&quot; below. &nbsp;Meaning if it hasn't been set to anything yet then return 0 by default. &nbsp;How do I do that?<br />
<br />
private mSheet as long<br />
<br />
Public Property Get Sheet() As Long<br />
&nbsp; Sheet = mSheet<br />
End Property<br />
<br />
Thanks,<br />
axnst1
</div>
</div>


I am trying to set a default value for "sheet" below.  Meaning if it hasn't been set to anything yet then return 0 by default.  How do I do that?

private mSheet as long

Public Property Get Sheet() As Long
  Sheet = mSheet
End Property

Thanks,
axnst1

Defult value of an object

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.