Hello All,
I have a userform that I'm working on where I want to be able to "send" data entered in textboxes to a certain worksheet based on what page is selected. I have the following code (which is not working):
Private Sub subcmd_Click()
Dim c As Range
Dim month As String
Dim year As String
month = Me.monthcb.Text
year = Me.yrcb.Text
Select Case worksheetchoose
Case 0, UserForm2.MultiPage1.MultiPage3.multipage9.Pages(0) = True
Sheets("DUN Earned").Select
For Each c In Range("A:A")
If c.Value = month And c.Offset(0, 1).Value = year Then
c.Offset(0, 2).Value = Me.dunimerndtb.Value
c.Offset(0, 3).Value = Me.dunctserndtb.Value
c.Offset(0, 4).Value = Me.dune70erndtb.Value
c.Offset(0, 5).Value = Me.duncorvetteerndtb.Value
c.Offset(0, 6).Value = Me.dunf25erndtb.Value
c.Offset(0, 7).Value = Me.dunxtserndtb.Value
c.Offset(0, 8).Value = Me.dunf15erndtb.Value
c.Offset(0, 9).Value = Me.dunctsngerndtb.Value
End If
Next
Case 1, UserForm2.MultiPage1.MultiPage3.multipage9.Pages(1) = True
Sheets("DUN Clocked").Select
For Each c In Range("A:A")
If c.Value = month And c.Offset(0, 1).Value = year Then
c.Offset(0, 2).Value = Me.dunimclkdtb.Value
c.Offset(0, 3).Value = Me.dunctsclkdtb.Value
c.Offset(0, 4).Value = Me.dune70clkdtb.Value
c.Offset(0, 5).Value = Me.duncorvetteerndtb.Value
c.Offset(0, 6).Value = Me.dunf25erndtb.Value
c.Offset(0, 7).Value = Me.dunxtserndtb.Value
c.Offset(0, 8).Value = Me.dunf15erndtb.Value
c.Offset(0, 9).Value = Me.dunctsngerndtb.Value
End If
Next
' Case 2
' ws = Worksheets("SLI Earned")
'
' Case 3
' ws = Worksheets("SLI Clocked")
End Select
End Sub
Additionally this code runs very slow, any suggestions for how to speed this up would be appreciated.
Thanks in advance,
Brad
Bookmarks