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
Tag: insert
What is the syntax to insert a row?
Range(“<row reference>”).EntireRow.Insert
‘example Range(“3:6”).EntireRow.Insert ‘inserts 4 rows from row 3
What is the syntax to insert a column?
Range(“<column reference>”).EntireColumn.Insert
‘example Range(“C:D”).EntireColumn.Insert ‘inserts 2 columns from column C
What is the syntax to fill a string with spaces?
Space(number) ‘number is number of spaces
'example MsgBox ("First" & Space(2) & "Second" & Space(20) & "Last")
What is the syntax for adding a worksheet?
'to add a sheet at the very beginning of the Sheets tab Worksheets.Add Before:=Worksheets(1) 'to add a sheet at the very beginning of the Sheets tab Dim shtLast As Worksheet Set shtLast = .Worksheets(.Worksheets.Count) Set shtNew = Worksheets.Add(After:=shtLast) 'to add multiple sheets before the active sheet ThisWorkbook.Worksheets.Add Count:=<number of sheets you want to add> 'to add a new sheet before the current active sheet Dim sht as Worksheet Set sht = ThisWorkbook.Worksheets.Add sht.Name = "<name of new worksheet>"