Title: Using Excel Macros to Process Real Time Data Acquired by the Excel Server from LowCostBoards.com
Video:
Description:This video shows how to use an Excel macro and a very small VBA program to display a scrolling chart of real time data aquired by the Excel Server from LowCostBoards.com
Title: Data Validation 8 - Custom Error Messages in ExcelVideo:
Description:Visit www.TeachExcel.com formore, including Excel Consulting, Macros, and Tutorials. Learn how to create custom error messages with this free Excel video tutorial. This shows you how to change the default data validation error messages to something that actually describes the error that was encountered. This is a particularly important feature to use when you need to let users know exactly what the error was that they caused so that they know how to correct the error. This tutorial shows you how to change the error message image, title, and error message itself. This is a very important feature of data validation that should be implemented in most cases where there is data validation present in Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Data Validation 6 - Run Macros from Drop Down Menus in Excel
Video:
Description:Visit www.TeachMsOffice.com formore, including Excel Consulting, Macros, and Tutorials. Excel video tutorial that teaches you how to run macros from drop down menus in Excel. This Excel video tutorial walks you through the steps you need to take in order to make a macro run when you select an option from a data validation drop down menu in Excel. This includes teaching you how to create the drop down menu in Excel; how to create the basic macro to run based off of the drop down menu; and, how to change the macro to run your own macro code. This is a really great tutorial to view in order to perform more powerful tasks with your drop down menus and lists in Excel. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Title: Data Validation 5 - Create Drop Down Menus That Accept Other Values in Excel
Video:
Description:Visit www.TeachMsOffice.com formore, including Excel Consulting, Macros, and Tutorials. Excel video tutorial that describes how to enter data into cells that contain drop down menus using data validation. This method teaches you how to be able to enter data into a data validated drop down menu cell that is not contained within the drop down menu. Basically, you will be able to enter values that are not contained in the drop down menu into a cell with a drop down menu. This allows you to simply use the data validation drop down menu feature in Excel in order to make entering values in cells easier for users while at the same time not preventing them from entering other values. For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
