else if

Hi Guys, I'm usually OK with if statements but when it comes to multiple criteria i tend to get a bit confused. Basically when a date is inputted that falls between the below date range i want the output in the next column to be the academic year. Hope that makes sense guys! Cheers...

Trying to run a quick script to pull a few names out of a string and place them in the column next to the string location. Cant seem to get this going. Any tips would be greatly appreciated. Sub james() Dim celltxt As String celltxt = ActiveSheet.Range("d4").Text If InStr(1, celltxt, "Sue")...

Hi. Sorry, new to this. Need to find a way to semi process some data. Perhaps easier to demo with a table. My data is column A has changing values, ie site names is not a constant, but the rest of the text is. I have about 50 of these statements. Each of these statements can be associated with a...

I have three blank text boxes in a UserForm. All of them should not be blank, or It gets message 'Fill All of Them' and also, if the value in the third text box is not a Date format, I want a message box "Enter A Date" Somehow,, my code is not working.. Please somebody help me out.. ElseIf...

Hello all mrexcel members, If you look at my picture below it’s excel There are first subtitles on the first row, and different columns: “c++ object” and “translate this column”, then language combinations in different columns. The thing is, with the column “c++ object” and “translation...

I am having a problem when a macro runs. IF I don't want to delete order data, it should do nothing and return to the front sheet. IF I do want to delete data, it runs the correct process. At the end of my coding under ELSE, it will show a dialog box advising a user to re-enter a year, but it...

Hello, Currently I am trying to use Elseif statments to copy and paste information into a target cell from another cell on the same worksheet based on the value of the target cell. When I try to run my code, I recieve the following error message: 'Run-time error 1004: Application-based or...

Hi, I have a particularly perplexing issue. The following code sometimes works and sometimes doesn't. I am using the Else If because the Select Case couldn't find it at all. The variable is exactly as the if statement, without the "". For instance '[CN caloriecalculator.xlsm]TDC'!$B$10 should...

Hi There, I was wondering how I would go about making condition variables to use in IF statements. The end result of the code is to calculate the total number of hours that a project has been worked on based on a starting time and date and ending time and date. However, there are two breaks and...

I'm trying to see if a worksheet is already created. If it is Im calling UserForm2, but if its not it will create the new sheet. When I do this I get "Compile Error: Else without If". Any help would be appreciated. For k = 1 To Worksheets.Count If Worksheets(k).Name =...

Hi! This is my first post so I apologise in advance if I do something wrong! I am very much a novice VBA user. I've been teaching it to myself so I can use it for my honours year thesis. I'm not sure if I have done something ridiculous here but I've included my code so you all can see. I keep...

my code looks like this so far legend for coding/question below newvariable is the variable name for an inputted value ...A actions -the commands if the value is A ...X actions - commands if the value is not A or B if newvariable = "A" then ....A Actions else .....X Actions...

I have this code: For i = 7 To 2000 If Range("L" & i) <= (Date - 365 * (3 * Range("N" & i))) - 182 Then Address = Cells(i, 15) strbody = "Relief Valve number " & Cells(i, 1) & " at " & Cells(i, 2) & blank & Cells(i, 3) & Cells(i, 4) & " needs to be tested"...

This is an Awesome Forum!! Just recorded my first macro. It works pretty good, but I there are some errors in it. Here's what I want it to do. 1. Unprotect the "Areas" sheet so the macro can run. 2. Delete all info in given ranges in the "Invoices" sheet. (See macro below for ranges) 3...

Hello to those that take the time to read this and thank you. I am not asking for anyone to do my homework only I have not been able to find a solution so far. Scenario: I need a macro/VBA to look in a range of about 20 cells. The cells have an if statement that pulls data from a cell...