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

...50 I want to sum all the codes that contain "ABC". Unfortunately, SUMPRODUCT won't allow it conventionally, in the form: =SUMPRODUCT((Code="ABC")*(Total)) I tried to nest MID and pull out that part of the string, but I couldn't get it to work. I then tried SUMIF and couldn't get that work...

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

...goes in the bottom-right corner of your sheet). The data table is below: Y Z 1 GL# Total 20 10000 =SUMPRODUCT(($B$3:$B$6=$Y20)*($C$3:$C$6)) 21 10001 PASTE 22 10002 PASTE 23 10003 PASTE Here's your data table: 1 A B C 2 Item...

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