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...

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...

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...

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...

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...

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...

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...

I have a list of people and codes. There are duplicates in the people list (no greater than one duplicate per name), but the codes are unique. So, John Doe could be listed only twice, while having two unique codes. How can I alter the following formula so that it returns the other code (instead...

Sorry to raise a non-technical question here, but I can't think of any better place to get the technical "skinny" on this topic: I'm tire of my MS Windows OS (the security issues and having to download patches on a weekly basis) and I'm looking to switch to a Linux product. Even...

I'm using SUMPRODUCT and need to exclude a particular variable from my SUMPRODUCT criteria. How do I do this? For example, I have a table of all cities(col.A) in all states(col.B) in the US. There's also a field with the population of each state(col.C). If I wanted to Sum the population of...

I have a SUMPRODUCT formula that's not returning all the data I need it to and I suspect it's because I'm using AND/OR incorrectly. The formula reads across four spreadsheets (two named ranges per sheet), and the formula operation specific to each of the four sheets is seperated with a...

i'm looking for some VBA code (rather, I found what looks like a pretty good starting point that needs some tweaking) that will return unique values from a list of duplicate values. Here's my example... say, my lookup value is "xxxxx". I want to put "xxxxx" in the code to...