Free for PREMIUM members
Learn how to a build a cloud-first strategyRegister Now
Private Sub Calendar1_Click()
' this code gets it to the userform
TextBox1.Text = Format(Calendar1.Value, "mm/dd/yyyy")
' this code gets it to the spreadsheet
sheets("Sheet1").Range("A1").value = FormInput.TextBox1.Value ' or it could be FormInput.TextBox1.Text
Private Sub userform_activate()
Calendar1.Value = Date
Open in new window
Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.