How to Create Dynamic, In-Cell Buttons and Toggles in Microsoft Excel

Published: 25 March 2018
on channel: Adventures in CRE
47,149
246

This tutorial shows you how to create theme-appropriate, dynamic in-cell buttons and toggles in Microsoft Excel. The video is recorded from a real estate financial modeling perspective, but is useful for other disciplines.

00:00 - Introduction
03:07 - Demonstrating the first button and toggle
06:50 - Workbook setup and creating a named cell
08:32 - Conclusion of the first segment
09:01 - Setting up the "Module On" cell
10:08 - Creating the "Turn Off" button
15:30 - Creating "On" and "Off" cells for the toggle
17:32 - Turning toggle cells into toggle buttons

To view the blog post related to this tutorial and/or download the Excel Workbooks (blank and completed) used in this tutorial, go to: https://www.adventuresincre.com/how-c...

To learn more about the author or to contact him, visit: http://www.SpencerBurton.org


Watch video How to Create Dynamic, In-Cell Buttons and Toggles in Microsoft Excel online without registration, duration hours minute second in high quality. This video was added by user Adventures in CRE 25 March 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 47,149 once and liked it 246 people.