block if without end if

  1. G

    Block If without End If Compile Error

    Hello All, I have searched the boards and looked elsewhere but for whatever reason I cannot get this code to work for a password/login function I created. Whenever I enter the login credentials I get hit with a Compile Error: Block If without End If... I've had a few people look at it and we...
    • GoCavs
    • Thread
    • block if block if without end if compile error vba & excel 2013
    • Replies: 2
    • Forum: Excel Questions
  2. C

    Need Help with Creating an If-Then Statement

    I just started learning the ropes to VBA and don't fully understand it yet. I am trying to create something that will change the value of two different cells, based on the contents of one cell. Specifically, if the text in column B says "shoecare", then the contents in column E need to change...
    • Catlover22
    • Thread
    • basic function block if without end if if then statement loop loop and copy
    • Replies: 5
    • Forum: Excel Questions
  3. M

    if - else - then - elseif vba code

    Hi all, I'm having a bit of a night mare. with some simple code that you lot will no doubt be able to fix instantly. The code is simple: Dim time As Integer, result As String time = Range("K3").Value If time > Range("k15") Then MsgBox "K3 value exceeds total time of test. Lower value"...
    • MrSak87
    • Thread
    • block if without end if else if statements if statement then msgbox
    • Replies: 4
    • Forum: Excel Questions
  4. N

    VBA Search - Block If Without End If

    I have a list of zip codes and a worksheet (main page) with a search box. I have a function to check the zip code is valid (it works so I haven't pasted below). If it is valid but not in my list, a message appears to the right of the search box. If it is in the list I want it to paste into a...
    • npm26
    • Thread
    • block if without end if end with error search vba
    • Replies: 1
    • Forum: Excel Questions
  5. E

    compile error: Help Please

    Block if without end if Private Sub Worksheet_Change(ByVal Target As Range) ' MsgBox (Target.Rows) If Target.Column = 9 Or Target.Column = 10 Then Dim v1 As Single Dim vx As Single v1 = Cells(Target.Row, 9) vx = Cells(Target.Row, 10) If v1 > 1 And vx > 1 Then...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top