pass

Good Morning I hope someone can help. What I need to do using VBA is Select a file Using the windows menu tree. Then pass the directory path & file name to variable1 and just the filename to variable2. Many thanks Kev

Hi, I am trying to write a macro which cycles through column B (after row 7) of my ("Macro_Summary") sheet and deletes the entire row if the cell in column B doesn't contain one of the following names: The names should be on an exact match basis (i.e. "Jerry" would pass, but "Je_rry", "Jerry...

This is really a math question, I guess, but I'm sure I can use an Excel formula(s) to calculate it. Here's the scenario: If Trucker A is traveling 75 MPH and Trucker B is behind Trucker A and traveling 75.00146 MPH. Trucker B decides to pass Trucker A. How long will it take Trucker B to pass...

I am looking for a formula to do the following: Cell a1 = -0.047 Cell b1 = ±0.060 I want cell c1 to show a "PASS" if cell a1 is less than cell b1 show a "FAIL" greater than b1 Any ideas would be helpful. Thanks

I am trying to add some more data and functionality to an existing database and having trouble figuring out how to pass the value that is being passed to main form also to the sub form. The reg# on main form is unbound. The reason the Reg# is passed as a variable I think is because that variable...

I’m fairly new to Excel macros. I have an Excel 2016 form that I’ve created for some data entry. I want to be able to run a PowerShell script when a particular cell is selected. My issue is I can run a PowerShell script but I can’t figure out how to pass 2 parameters to the PowerShell script...

I have a test which is to see if people can correctly caluclate Log10s propperly. I have excel working it out in hidden cells. I want a cell to say "Pass" if they type the correct answer in or "Fail" if not. I have done this ( =IF(A1=A2,"PASS","FAIL")) and it all works, as long as you type in...

I was not able to find an answer anywhere, so now I wondering if my approach is wrong. This is the formula I am using =IF(ISNUMBER(SEARCH("pass",$J$1)),"pass",IF(ISNUMBER(SEARCH("fail",$J$1)),"fail","")). This formula does work but now I need it to read row G through J. It needs to be able to...

Hi guys. Need some help with an If Statement if you please. =IF(W7="Fail",IF(W8="Pass","A",IF(W7="Fail",IF(W8="Fail","R",IF(W8="",IF(W7="Pass","G")))))) W7 and W8 are combo boxes (Blank, Pass, Fail) By selecting W7 Fail and W8 Pass, it returns A By selecting W7 Fail and W8 Fail, it returns R...

I am most likely going about this all wrong but here goes nothing... I am trying to pass a dynamic value into a textbox. My textbox reads something like this: Case(s) A, B, C, D generated given scenario(s) 1, 2, 3. There was/were X ProductType1 and Y ProductType2 totaling $$$$ I have my...

Hi Everyone, I have spent way to much time trying to connect everything into one formula, to the point where i am not sure if it can be done. Hopefully my explanation below is not too confusing. I need to make the following work: If cell C2 contains Apple,Orange or pear and cell D2 is less...

I'm trying to set passed arguments directly to an array for ease of use. As an example what I currently do is similar to: Sub Macro1(arg1 As String, arg2 As String, arg3 As String, arg4 As String)Dim args(1 to 4) as String args(1) = arg1 args(2) = arg2 args(3) = arg3 args(4) = arg4 for a = 1 to...

I need your help excel heroes in debunking this formula. What's the formula if i want to automatically mark x in worksheet 1 if john's training result in worksheet 2 is pass Worksheet 1 <tbody> name safety training John x </tbody> Worksheet 2 <tbody> Name...

hello, I have tried to do this my self but this is abit bigger than my skill set, im trying to make my grading spreedsheet easier for me to read, I have want to have it so that when ever I pass the pass work I want it to come up with pass and then when I pass merit, I want it to say merit, so...

Greetings. I've Excel 2016 spreadsheet that I created that captures the following information per these columns:A = Operator number B = Serial number of part being tested C = Date / Time (this is auto-filled once the Serial No. is scanned into prior field) D-F = test set-up confirmations G-AD =...

Here's the type of data I'm dealing with. I know that it would be considerably easier if it was one row per defect, but each row on the defect has other unique information in it (That I don't need for the summary) but do for other purposes so can't delete it) <tbody> Column A Column B Column C...

Very beginner question: what does it mean to "pass arguments"?

I have a simple formula in cell A1 that points to a cell on a different sheet ("=Sheet3!J4"). However, need to change this to make is more dynamic. For instance, I need the actual cell reference part (J4) to be more dynamic. So in some cases I may want to pass a different row. How can I write...

I can pass one variable ok, but I need to pass 2. Doesn't seem to work.. Is there an example with 2 variables? Public Property Let iItem (aa As String, v As Integer) ... do stuff End Property Dim Test as Popup Set Test = New Popup Test.iItem = "Fred", 9 ("Fred", 9) in brackets nogo either.

Hi all, So far I love tweaking it all and taking my first steps in Excell. I've been looking around, but I can't seem to find a simple solution. What I would like to do now is to pass variables from one sub to another (all in the same module). The idea is simple. I have a sub, where I call 2...