Saturday 18 December 2010

Use Excel Scroll Bar to Change Worksheet - No Macros

Title:
Use Excel Scroll Bar to Change Worksheet - No Macros


Video:


Description:www.contextures.com With a simple Excel scroll bar, and no macros, you can show different messages on a worksheet. This Excel scroll bar example also uses conditional formatting, to show and hide coloured cells on the worksheet. The Excel VLOOKUP function is used to show the correct message in a text box. Drag the scroll bar to show or hide the Christmas tree decorations and gifts. Use these techniques in your business workbooks too! Watch this video to see how to use an Excel scroll bar to change the worksheet appearance, without Excel VBA.

Published:
19/Dec/2010

No comments:

Post a Comment