Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 194
  • Last Modified:

Excel Template - Nice looking control worksheet

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,
2 Solutions
Glenn RayExcel VBA DeveloperCommented:
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 Chandoo.org:

Jerry PaladinoCommented:
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
montrofAuthor Commented:
Thank you both, this got me on the right track.  I like the simple clean approach.

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now