Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

July 2008 - Daily Dose of Excel

Sort by: Most Recent | Most Viewed | Most Commented

  • The NEW Spreadsheet Page

    Finally, I redesigned The Spreadsheet Page. The official launch is Friday, but you can take a sneak peek if you're interested. Out with FrontPage, and in with Expression Engine. Man, that's some powerful software. The site is all database driven now, so it will be much easier to maintain and update. Feedback is welcome. If [...] Read More...
    Filed under:

  • Multiple Add-ins

    I'm creating several add-ins that will all use the same top-level menu item. The add-ins will be installed as needed. So someone may have just one and someone else may have half a dozen. The right answer, I think, is to have one controlling add-in that handles the menus (and not much [...] Read More...
    Filed under: ,

  • Filter by Selected Cell’s Value, Cell’s Color or Cell’s Font Color

    Hi all After creating and testing a lot of code to filter on normal and on Conditional Formatting colors I came up with a nice and easy solution I think. I made this page for Excel 2007 http://www.rondebruin.nl/colorfilter2007.htm Suggestions are welcome Ron de Bruin http://www.rondebruin.nl/tips.htm Read More...
    Filed under: ,

  • Free Excel Stuff

    Giveaway of the Day I like the comments from the OpenOffice users. Jeez, does everything have to be open-source? Read More...
    Filed under: ,

  • List Userform Hotkeys

    I hate trying to figure out which hotkeys are available when I need to add a control to a userform, so I wrote a procedure to list them. Sub ListHotKeys(uf As UserForm)         Dim ctl As Control     Dim aKeys() As String     Dim sKey As String     Dim i As Long, j As [...] Read More...

  • FillSeries Keyboard Shortcut

    I have never found a decent keyboard shortcut for filling a series, despite being the self-anointed king of all things keyboard. Oh sure, I could Alt+E, I, S, Enter, but it's just not satisfying. So in the vein of selecting adjacent columns, I added a macro to my Personal.xls. Sub FillSeries()         [...] Read More...
    Filed under: ,

  • Determine Which COM Add-ins Are Installed

    The COM Add-in (Component Object Model) toolbar button is not on any toolbars by default. You have to add it and then click on it to get to the COM Add-in dialog. First, right click in a blank area around the toolbars and choose Customize Go to Tools on the left and COM Addins [...] Read More...
    Filed under: ,

  • Andrew’s Excel Tips

    Just a quick post to let everyone kind enough to visit - my site address has now changed to www.andrewsexceltips.net (formerly www.andrewsexceltips.com). I’ve been blogging for over 4 years now, and although I don’t post as often as I used to, I’m still cooking up new stuff to add. Thanks to Dick and my other great Excel [...] Read More...
    Filed under:

  • Peltier Loves Pie

    I’m testing out widgenie (beta) and want to see how an embedded chart looks. I chose a pie chart because I’ve been reading lately how we all know pie charts are bad. Anyway, this took about 10 seconds to create with Debra’s sample data. var myLogiWidget477e7c06_b129_47f5_b60b_617dfb112792 = new rdLogiWidget; [...] Read More...
    Filed under: ,

  • Lookup Second Occurrence

    I need to do a VLOOKUP but find occurrences later than the first one. I've listed out all of my assemblies and all of their component parts like so: Parent Child Quantity To list the the children of a particular parent, I need a function that can find multiple occurrences of the parent. I considered [...] Read More...

  • Office Community Clips

    Have you seen the new Microsoft Office Community Clips? People upload videos that demonstrate how to perform a task. I guess people like this because it's almost like watching TV. Never mind that you actually have to click and watch in order to determine if it's useful. And, a 3-minute video contains roughly the same content [...] Read More...
    Filed under:

  • Excel Links

    First, from the double trademark infringement department, there’s Excel®RainMain®, who says: Whether it’s your homework, day job, or just a new idea, let the Excel Rain Man make your life easier! Submit a Request, inquiries are free! (see How it Works for further details) Pay for homework service? For a fee, I’ll read your lit homework [...] Read More...
    Filed under:

  • To Disable or Not To Disable, That Is the Question

    Joel Spolsky says don’t: Instead, leave the menu item enabled. If there’s some reason you can’t complete the action, the menu item can display a message telling the user why. I thought it was pretty common knowledge that users don’t read message boxes. Anyway, I’m squarely in the disable-menu-items-that-aren’t-applicable camp, and I never hide items. Take the [...] Read More...
    Filed under:
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.