What is the syntax to open a userform?

<userform name>.Show

'example
frmHome.Show

 

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 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 change a button’s display text?

 <button name>.Caption = "<new text>"

'example
btnPause.Caption = "Resume"

 

What is the syntax to open a userform in the top-right screen corner?

 Me.StartUpPosition = 0
 Me.Top = Application.Top + 25
 Me.Left = Application.Left + Application.Width - Me.Width - 25

'example - place in UserForm_Activate procedure
Private Sub UserForm_Activate() 'when form opens
   Me.StartUpPosition = 0
   Me.Top = Application.Top + 25
   Me.Left = Application.Left + Application.Width - Me.Width - 25
End Sub

 

Tips for User Interface Design [updating]

1. Use simple dialog understandable by your target user (ie) no jargon
2. Rely little on user memory (ex) lesser steps for user to memorize/follow
3. Output meaningful error messages (ex) when error happens, tell them using normal english vs something like “error code 1035”
4. Avoid limitless choices (ex) Give them a limit of choices as often as possible, vs an open text field that could produce all sorts of data mismatch errors
5. Always have an exit (ie) never put user in a place where they cannot go back or get out
6. Exploit consistency (ie) familiarity equates speedy learning
7. Provide continuous feedback (ex) instead of just a loading bar, have a label underneath that tells the user what step the computer is on
8. Purpose (not beauty) dictates design (ex) look at how ugly but popular sites like Reddit, Craigslist are

What is the syntax to auto-move days on a calendar?

<calendar name>.Value = <calendar name>.Value <+/-> <number of days you want to move forward or back>

‘examples
myCalendar.Value = myCalendar.Value + 1 'move forward one day
monthview.Value = monthView.Value -5 'move backward 5 days

What is the syntax to get the date selected for a calendar?

1. Add a calendar to your userform (for instructions, click here)
2. As shown in the screenshot below, select your calendar control (default name is always MonthView1)
3. Select DateClick, as shown circled in red below
4. A procedure will be auto-generated, containing a parameter called DateClicked
5. User’s selected date is automatically contained in variable DateClicked

What is the syntax to add a calendar to a userform?

VBA IDE > View > Toolbox > Right-click on Toolbox window > Additional Controls > check Microsoft MonthView Control 6.0 (SP6) > In Toolbox, select MonthView control > drag calendar onto your userform

What is the syntax to set a label’s value?

<label’s name>.Caption = “<text>”

'example
lblExample.Caption = “Hello”

What is the syntax to open a userform?

Put the code below in a separate module from that of the userform. A common choice for users is the proceduce of Workbook_Open() under module ThisWorkbook.

Private Sub Workbook_Open()
    <user form name>.Show
End Sub

 

Do not use the load method, as this just loads the form but does not make it visible. Besides, Show option automatically loads it anyway.

Load <user form name>