Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When this code is run i get the end if without block if error, but i
don't see what i am doing wrong. It highlights the very first "if" statement Private Sub btnSubmit_Click() Sheets("rewards tracker").Activate If Left(cmbDate.Value, 3) = "Sun" Then For i = 1 To txtQty.Value Step 1 txtholder.Value = Me.Controls("txtNum" & i).Value Rows(txtholder.Value + 4).Select Selection.Cells(3) = Me.Controls("txtRew" & i).Value ActiveCell.Offset(0, 1) = Me.Controls("txtTot" & i).Value ActiveCell.Offset(0, 3) = Me.Controls("txtNew" & i).Value Next i ElseIf Left(cmbDate.Value, 3) = "Mon" Then For i = 1 To txtQty.Value Step 1 txtholder.Value = Me.Controls("txtNum" & i).Value Rows(txtholder.Value + 4).Select Selection.Cells(8) = Me.Controls("txtRew" & i).Value ActiveCell.Offset(0, 1) = Me.Controls("txtTot" & i).Value ActiveCell.Offset(0, 3) = Me.Controls("txtNew" & i).Value Next i ElseIf Left(cmbDate.Value, 3) = "Tue" Then For i = 1 To txtQty.Value Step 1 txtholder.Value = Me.Controls("txtNum" & i).Value Rows(txtholder.Value + 4).Select Selection.Cells(13) = Me.Controls("txtRew" & i).Value ActiveCell.Offset(0, 1) = Me.Controls("txtTot" & i).Value ActiveCell.Offset(0, 3) = Me.Controls("txtNew" & i).Value Next i ElseIf Left(cmbDate.Value, 3) = "Wed" Then For i = 1 To txtQty.Value Step 1 txtholder.Value = Me.Controls("txtNum" & i).Value Rows(txtholder.Value + 4).Select Selection.Cells(18) = Me.Controls("txtRew" & i).Value ActiveCell.Offset(0, 1) = Me.Controls("txtTot" & i).Value ActiveCell.Offset(0, 3) = Me.Controls("txtNew" & i).Value Next i ElseIf Left(cmbDate.Value, 3) = "Thu" Then For i = 1 To txtQty.Value Step 1 txtholder.Value = Me.Controls("txtNum" & i).Value Rows(txtholder.Value + 108).Select Selection.Cells(3) = Me.Controls("txtRew" & i).Value ActiveCell.Offset(0, 1) = Me.Controls("txtTot" & i).Value ActiveCell.Offset(0, 3) = Me.Controls("txtNew" & i).Value Next i ElseIf Left(cmbDate.Value, 3) = "Fri" Then For i = 1 To txtQty.Value Step 1 txtholder.Value = Me.Controls("txtNum" & i).Value Rows(txtholder.Value + 108).Select Selection.Cells(8) = Me.Controls("txtRew" & i).Value ActiveCell.Offset(0, 1) = Me.Controls("txtTot" & i).Value ActiveCell.Offset(0, 3) = Me.Controls("txtNew" & i).Value Next i ElseIf Left(cmbDate.Value, 3) = "Sat" Then For i = 1 To txtQty.Value Step 1 txtholder.Value = Me.Controls("txtNum" & i).Value Rows(txtholder.Value + 108).Select Selection.Cells(13) = Me.Controls("txtRew" & i).Value ActiveCell.Offset(0, 1) = Me.Controls("txtTot" & i).Value ActiveCell.Offset(0, 3) = Me.Controls("txtNew" & i).Value Next i End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
End If without Block If Error Help | Excel Programming | |||
Compile error: End If without block IF | Excel Programming | |||
VBA error - End If without Block If | Excel Worksheet Functions | |||
Error - End If Without Block | Excel Programming | |||
Error 91, Object var or With block not set | Excel Programming |