<userform name>.Show
'example frmHome.Show
Advertisements
<userform name>.Show
'example frmHome.Show
Format(<value>, "<formatting convention>")
'example - outputs 2 decimalNum = 2.31321 Msgbox Format(decimalNum, "0")
<listbox name>.Clear
'if clearing a userform's listbox from outside the userform
<userform name>.<listbox name>.Clear
'example formHome.lstOutput.Clear
<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
<listbox name>.AddItem <value to be added>
'example - userform called formHome exists formHome.lstGuests.AddItem "Tristan Smith"
Call <procedure name>
'example Call loadSheet Sub loadSheet() 'code here End Sub
'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