Excel Tips
Why Does Office 365 Have Better Features? »
July 5, 2021
I have Geography and Stock Data Types at home, but not at work, What is going on?
List Combinations Of N Items Taken M At A Time »
July 2, 2021
You want to list all unique combinations of m items from a population set of n items. For example, you might want to generate all possible unique groups of 4 employees from a set of 10.
Magnify A Section Of Your Screen »
June 30, 2021
You would like to display 48 months of data across your monitor. When you zoom down to 40%, you can see all the columns, but you cannot make out any numbers on the screen.
Self-sign Your Macros For Co-workers »
June 28, 2021
You’ve created some macros for co-workers to use. Having them click Enable Macros each time is tiresome, but you don’t want them to drop their macro security settings too low.
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.