Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Daily Dose of Excel » All Tags » General (RSS)

Browse by Tags

  • How Much to Charge for Freelance VBA Development

    $150 per hour. $120 per hour if the project is big enough that you won’t have to look for work for a while. $100 per hour if you’re really hungry. I’m sick of reading blog posts about how much to charge. They don’t tell me anything I don’t already know. And they [...] Read More...
    Filed under:

  • Sorting a Custom Collection Class

    I’ve been following Dick’s VBHelpers Build series (1, 2, 3) and his last post reminded me that, from time to time, I need to sort a collection of items in-memory. I don’t have to sort all that often, so my approach has changed over time. I’ve kind of settled on the following. Let’s say I have a [...] Read More...

  • Is it Standard Time yet?

    Part of my part-time job schedules world-wide PC-chat conferences weekly, and I announce the time referenced to the East Coast. As daylight savings time is about to end, I wanted an algorithm that knew whether standard time or daylight savings time was in effect. As I’m not worried about the 2:00AM change over, I can [...] Read More...
    Filed under:

  • Excel 2011 on the Mac

    Hi all FYI A few weeks back I start working on my first Mac, and I must say I love the OS but there is a lot of work to do in Office for the Mac. My idea is to go through all my webpages and see if I can make the VBA code also working in Excel [...] Read More...
    Filed under:

  • Pimping the Bootcamp

    There’s an Excel Power Analyst Bootcamp in our nation’s capital next month. Well not our nation’s capital, but mine. OK, it’s Washington DC. More like Alexandria, VA. Or it might be Springfield, VA. Just ask the cabbie to take you to the Sheraton in old town Alexandria. He’ll know [...] Read More...
    Filed under:

  • Highlight matches to the current cell

    I came across a very reasonable request from someone who wanted to see which entries in a list matched those in the current cell (http://answers.microsoft.com/en-us/office/forum/office_2010-excel/event/49aa9987-3cf5-4007-9f08-df076ff0beba). While the original request dealt with names, I abstracted the problem into a set of numbers. Column A in Figure 1 is one list of numbers. Column [...] Read More...
    Filed under:

  • Password Userform Module

    This was inspired by Dick Kusleika’s post Masking Passwords (http://www.dailydoseofexcel.com/archives/2011/07/12/masking-passwords/). It’s an enhanced version of DK’s approach in the sense that the same userform module supports both entering a new password as well as entering a password for confirmation. There are other enhancements. The user can choose to either mask or unmask [...] Read More...
    Filed under:

  • Enable or Disable custom Ribbon buttons in Excel 2007-2010

    Hi all FYI, I add this page last weekend to my site : Enable or Disable custom Ribbon buttons in Excel 2007-2010 http://www.rondebruin.nl/enable.htm I also have a page for hiding and displaying : Hide or Display Custom Ribbon Tab/Group/Control with getVisible http://www.rondebruin.nl/hidevisible.htm If you have suggestions or good or bad comments let me know(I am no expert) Ron de Bruin http://www.rondebruin.nl/tips.htm Read More...
    Filed under:

  • Opening Paint files in XL

    Specifically, MacPaint files. Why MacPaint? 1. With a maximum size of 576 pixels wide by 720 pixels tall, MacPaint images fit on a modern spreadsheet when using cells as pixels, and 2. MacPaint prototyped the lossless PackBits compression algorithm, which is the default compression scheme for TIFF. PackBits is a signed-byte file structure with [...] Read More...
    Filed under:

  • Remap Num Lock Key

    A few years ago I remapped my Caps Lock key and I’ve never been happier. Until now. Do you ever try to do a quick calculation in Excel and forget the equal sign? Do you ever start typing a number and end up in a different cell? If these have happened [...] Read More...
    Filed under:

  • How to retire after selling one copy of a book

    Amazon seller lists book at $23,698,655.93 — plus shipping http://www.cnn.com/2011/TECH/web/04/25/amazon.price.algorithm/index.html?iref=NS1 which references Amazon’s $23,698,655.93 book about flies http://www.michaeleisen.org/blog/?p=358 – Tushar Mehta Read More...
    Filed under:

  • Excel and Access Training

    It’s time once again for the Excel and Access Power Users Workshop put on by Data Pig Technologies and DDoE. It’s in Chicago this year on May 18th-19th. Here’s what you’ll learn: Move Data between Excel and Access Leverage advanced MSQuery and SQL Techniques to Enhance Reporting Use PowerPivot to Simplify Database Connectivity Automate Excel from Access Run Access Macros [...] Read More...
    Filed under:

  • loss of state of the global IRibbonUI Ribbon object

    Hi all There is a common problem when you are working with the Ribbon with RibbonX and VBA. The ribbon object (which is initialized when Excel loads your file) can loose its reference to the ribbon, which means your code can no longer tell Excel to update your ribbon customizations. There is simply no easy built-in way to recover [...] Read More...
    Filed under:

  • Introducing TM Retro Slicer beta 1

    Those who have used an Excel 2010 slicer may have wanted to see that capability in earlier versions of Excel. I like what Microsoft did with slicers in 2010 and wanted to extend that capability backwards. For those who haven’t used a slicer, it is a filter on a particular pivot field shown [...] Read More...
    Filed under:

  • Credit Card Processors

    Charles asks about credit card processors for accepting payments from clients. Like me, he uses Paypal, but would like to explore some other options. If you’re a freelancer or otherwise accept credit cards, who do you use? I’m not sure what the criteria should be, but here’s my list Reasonable transaction fees Easy to [...] Read More...
    Filed under:
1 2 3 4 5 Next > ... Last »
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.