Excel Tips
June 25, 2021
You need to delete records that match a certain criterion, and you’d like to do it by using a VBA macro.
Format A User Form Text Box As Currency Or A Percentage »
June 23, 2021
You are building a custom user form to calculate a monthly payment, based on loan amount, number of payments, and interest rate. You would like one text box on the form to be formatted as currency and another to be formatted as a percentage. There do not appear to be a properties to format the text boxes.
Add A Right-click Menu To A User Form »
June 21, 2021
You’ve designed a custom user form. You want to add a right-click menu (also called a context menu) to it.
June 18, 2021
You have a worksheet that contains 10,000 rows of data. As people scroll through the workbook, you want the macro button to always be in view.
Remove The Caption Bar From A User Form »
June 16, 2021
You want to show a user form in Excel and prevent users from closing the form by clicking the red X close button in the corner.
Use A Macro To Highlight The Active Cell »
June 14, 2021
Microsoft changed the selection highlighting in Excel 2007. If you select 20 cells, Excel highlights those cells in super-ultra-light blue. Imagine if you had 5 gallons of white paint and dropped in one drop of blue paint. That paint would have more color than the new selection color in Excel 2007. You want to highlight the active cell so it’s easier to spot.
Add Filter To Selection Functionality »
June 11, 2021
Access offers a cool feature called Filter to Selection. If you are looking at a data sheet in Access, click the value XYZ in Field22 and click Filter to Selection, Access shows you only the records where Field22 is equal to XYZ. Excel does not offer this feature. Instead, you have to turn on the Filter (known as AutoFilter in Excel 2003 and before) and choose the desired value from the Filter dropdown.
Copy The Personal Macro Workbook To Another Computer »
June 9, 2021
You have a bunch of cool macros in your Personal Macro Workbook. You would like to get them in a co-worker’s Personal Macro Workbook.
Create Worksheet Names By Using The Fill Handle »
June 7, 2021
You type Jan into a cell, grab the fill handle, and drag down five cells. Excel types Marcia, Cindy, Bobby, Greg, and Peter. No, sorry. Excel types Feb, Mar, Apr, May, Jun. The fill handle can do all sorts of amazing fills, handling months, quarters, weekdays, dates, and so on. If you set up a custom list, Excel can even extend your list of departments, products, or Brady Bunch kids.