Learn how to add, configure and use checkboxes in Excel to create interactive task lists and trigger formatting without relying on macros. Recently, Microsoft has introduced the ability to add ...

Using Excel to create business forms means including elements available on your Web-based and paper forms, including check boxes. Like other Excel form elements, check boxes appear on the drawing ...

Looking to become an Excel power user? Excel has a number of features that will make it easier for you and your colleagues to enter data into your spreadsheets. If you’re developing a spreadsheet that ...

Here's how to build smarter checklists in Excel using checkboxes, conditional formatting and task dependencies to help with multi-step processes. In my previous article in this series, I walked you ...

Excel does not always handle a cluttered page very well, especially if you intend to use a workbook on multiple versions of Excel. In this example we will use the Worksheet_SelectionChange event as a ...

Microsoft Excel's form controls can turn the Boolean options of a true-false choice into a clickable data-entry option. If you create spreadsheets to record business information about sales, personnel ...

Create a UserForm containing a dynamic number of controls and make sure they are being triggered by certain events. To achieve this result, we will use a UserForm and a class module, and assign any ...

Excel is more than just a tool for organizing data and performing calculations. With the right techniques, you can transform your spreadsheets into interactive dashboards that engage users and provide ...

If you are a teacher, you have to create quizzes for students on a regular basis. Many free quiz maker software are also available but it can be risky to install them on your PC if they are not ...