Writing assignment statements
The following example assigns the return value of the InputBox function to the variable.
Sub Question() Dim yourName As String yourName = InputBox("What is your name?") MsgBox "Your name is " & yourName End Sub
The Let statement is optional and is usually omitted. For example, the preceding assignment statement can be written.
Let yourName = InputBox("What is your name?").
The Set statement is used to assign an object to a variable that has been declared as an object. The Set keyword is required. In the following example, the Set statement assigns a range on Sheet1 to the object variable
Sub ApplyFormat() Dim myCell As Range Set myCell = Worksheets("Sheet1").Range("A1") With myCell.Font .Bold = True .Italic = True End With End Sub
Statements that set property values are also assignment statements. The following example sets the Bold property of the Font object for the active cell.
ActiveCell.Font.Bold = True
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.