MYSYNTAX: VBA

What is the syntax to open a userform?

<userform name>.Show

'example
frmHome.Show

What is the syntax to format number output?

 Format(<value>, "<formatting convention>")

'example - outputs 2
decimalNum = 2.31321
Msgbox Format(decimalNum, "0")

What is the syntax to clear a listbox?

<listbox name>.Clear

'if clearing a userform's listbox from outside the userform
<userform name>.<listbox name>.Clear

'example
formHome.lstOutput.Clear

What is the syntax to see if a checkbox is checked?

 <userform name>.<checkbox name>.Value

'example
If formHome.chkActiveOnly.Value = True Then
    MsgBox "User has checked the box"
Else
    MsgBox "User has not checked the box"
End If

What is the syntax to add to a listbox?

<listbox name>.AddItem <value to be added>

'example - userform called formHome exists
formHome.lstGuests.AddItem "Tristan Smith"

What is the syntax to call a local procedure?

Call <procedure name>

'example
Call loadSheet

Sub loadSheet()
    'code here
End Sub

What is the syntax to retrieve all open workbooks in Excel?

'wb.Name holds the name of the open workbook
Dim wb As Workbook
For Each wb In Application.Workbooks
 <code here with involving wb.Name>
Next wb

'example
Dim wb As Workbook
For Each wb In Application.Workbooks 'for each open workbook, pass the name to lookupEGA()
   MsgBox wb.Name
   lstWorkbooks.AddItem wb.Name
Next wb