Format A User Form Text Box As Currency Or A Percentage

June 23, 2021 - by Bill Jelen

Format A User Form Text Box As Currency Or A Percentage

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

Solution: You can use the BeforeUpdate code to grab what the person types into a text box and format it properly. If someone types 20, you can have it automatically change to 20% when the user tabs out of the field.

continue reading »

More Reading

Add A Right-click Menu To A User Form

Add A Right-click Menu To A User Form »

June 21, 2021 - by Bill Jelen

You’ve designed a custom user form. You want to add a right-click menu (also called a context menu) to it.

Keep A Button In View

Keep A Button In View »

June 18, 2021 - by Bill Jelen

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

Remove The Caption Bar From A User Form »

June 16, 2021 - by Bill Jelen

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.

read more articles »

Featured Products

Your Excel Survival Kit - Second Edition

March 2021

This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.

Introduction to Financial Modelling

October 2019

With over 50 examples and an extended case study that creates a simple financial model from scratch to highlight the key concepts, this is a "hands on" book, focused on working with Excel more efficiently and effectively.

Power Excel With MrExcel - 2019 Edition

December 2019

This is the print book edition of "Power Excel with MrExcel - 2019 Edition" - by Bill Jelen. Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis.

Excel Insights – A Microsoft MVP Guide to the Best Parts of Excel

January 2020

There are fewer than 100 Excel MVPs worldwide. 24 of them have contributed to this book. Written, edited, reviewed and printed by Excel MVPs, this is practical Excel passion undiluted, with each MVP highlighting some of their favorite topics.

see more products »