Excel Template -  Nice looking control worksheet

Posted on 2014-07-14
Last Modified: 2014-07-15
Hi Experts,

I am looking for a nice looking template or look for a workbook that have created.  This the control page for the workbook so it contains the date selection and couple other selections and then it also has several macros that the user can run from the page.  I am just looking for a clean and useful design that I could use that would make it appealing to the user.  
Please provide an example if possible.

Thanks for the help,
Question by:montrof
    LVL 27

    Assisted Solution

    by:Glenn Ray
    It will be hard to give you good design examples without seeing your existing workbook.  

    If you are looking for good dashboard designs and methods, I recommend

    LVL 16

    Accepted Solution

    The attached PDF (and Pic) are a snapshot of a sample Control page for one of my applications.   Designs are what you find pleasing and can range across the board.   I think simplicity is better, but others prefer a lot of information on the page.  This one has input fields for Start and End Dates.   The VBA returns the last update and number of emails processed for end user feedback after the blue button has executed the macro.Control PageControl--2014-07-15-05.19.pdf
    LVL 1

    Author Closing Comment

    Thank you both, this got me on the right track.  I like the simple clean approach.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Suggested Solutions

    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now