Search results for query: *

I use the script below to search for names that appear in Column B of an excel worksheet. It's linked to a cell in which the name is typed. It works fine for a single name. However, if there are muliple records with the same name I cannot get it to "find next" when I hit the button a second...

I have some script that changes the visual effect of three buttons upon mouse-over, but the 7th line from the bottom highlights yellow during the event, indicating an issue. I do not know what is causing this. Here's the line: Set OleObj = Me.OLEObjects("Label" & i) Here's the script in...

Put policy in as your second data range. As a general rule, I "fool proof" the formula to ignore blank cells, as they'll limit the formula: So, your formula would be: {=SUM(IF(COUNTIF(POLICY,POLICY)=0," ",1/COUNTIF(POLICY,POLICY)))} NMC

I created a database in Excel and attached buttons to control macros. No problem. I'd like to add code that will change the appearance of the buttons from raised to sunken when the cursor/pointer moves over them, like in html app's. What code can I add to do this, and where should it go...

Thanks cLFLaVA--I appreciate your help. I'm having an issue with line 4, though: "If shtObj.Range("A" & i).Value = szSearch" Thanks. Monky

I've scoured probably 200 archives looking for this solution and I cannot find it... How can I add a Search Box to a worksheet? I want to configure it so that: - I type the name in a cell (let's say its D1) - Column A is queried - The cell in Column A that contains the word typed in D1 is...

Fantastic. Thanks, Tony for your help. It works perfectly. The ABS function is (for lack of a better word...) "neat". And thanks again, Blue. I did a search on old threads for this and saw a post of yours that suggests a test of: IF(ISERROR(0/A1," "... which was brilliant. That's now on my...

Hi Blue: Thanks for the formula. It works well, but I neglected to include a caveat: if the plan value is "0" then I get a Div# error; further, I'd like to add "if Actual is 20% above or BELOW plan (I think I left that out of the original post). I know the "IF(ISERROR(" trick, but integrating...

What would a formula look like to solve the following issue? Plan Actual Difference 5,000 1,000 4,000 What I want to do is this: If the Actual is 20% above of below the plan, then return the difference of the two numbers (if the actual was above plan, then the number would be...

Good solutions--thanks! NCM

It seems that Excel rounds upward by default at the .5 point in a whole integer. Is there a non-formula way (or non special format way) to get it to round downward at .5 (and below)? So, any increment above .5 would round upward; but any increment at .5 and less would round downward to the...

That works--thanks Ken! Regards. NCM

Outstanding. Fellas--thanks. Tony--Your formula works perfectly in this project. Skip--Your formula fits great in another report I'm creating(and probably 10 others I can think of). In fact, it precluded me from posting another question. Many, many thanks. Regards. NCM

I'm trying to configure SUMPRODUCT to use a part of a text string as my criteria. For example: A B C 1 Code State Total 2 123_ABC_456 NY 50 3 123_GHI-456 NY 50 4 234_ABC_567 NY 50 5 234_GHI_567...

Thanks, Steve, for your great help. I'll give this a shot. Regards. NCM

I love SUMPRODUCT because it does what SUMIF does, but one can use a cell reference instead of having to use a fixed "text" value--a huge plus since you can have many GL numbers. First, get a unique list of the GL numbers (select range, Data-->Filter - Advanced Filter; check "Copy to another...

In a nutshell, I have a list of projects to which I linked a graph that plots data dynamically, based on the active row of the list. I scroll up or down to a particular project title, press the button the macro is assigned to, and the graph is updated with the parameters that correspond to the...

In a nutshell, I have a list of projects to which I linked a graph that plots data dynamically, based on the active row of the list. I scroll up or down to a particular project title, press the button the macro is assigned to, and the graph is updated with the parameters that correspond to the...

Thanks a bunch luceze, stray and Glenn. Monky

Thansks for your help Luceze, but it returns the same code. I'm looking for a return of the other code. For example: A B C 1 NAME CODE FORMULA 2 John Doe 12345 23456 3 John Doe 23456 12345 Regards, NCM