I am stuck and can't seem to find the answer or overlooked the answer. Below is the code for my module to show the userform. This part works correctly.
The Userform loads properly, until I change the Userform1 to Userform, not sure why. Then I am getting a Automation error. Below is that code.
Any help on this would be greatly appreciated.
VBA Code:
Sub Log_Hours()
UserForm1.Show
End Sub
The Userform loads properly, until I change the Userform1 to Userform, not sure why. Then I am getting a Automation error. Below is that code.
VBA Code:
Private Sub UserForm1_Initialize()
Me.ComboBox1.List = WorksheetFunction.Transpose(Worksheets("Data Validation").Range("C2", Worksheets("Data Validation").Range("C" & Rows.Count).End(xlUp)))
Me.TextBox1.Value = "mm-dd-yyyy"
End Sub
Any help on this would be greatly appreciated.