Hi all,
I decided I need a bit more content on my site for the average to intermediate Excel users:
Apart from input cells chained to cells with formulas, there are other options in Excel to make your spreadsheet model more interactive. You can add option buttons, check boxes and list boxes to your sheet to offer choices to the user. Moreover, you can add scroll bars and spinners to quickly control values in cells. These elements are called controls because they enable your user to control the content of your model. This article shows how to put controls to use in your model.
Enjoy the read and let me know what you think!
Regards,
Jan Karel Pieterse
www.jkp-ads.com
I read the article “about controls on worksheet” but the only thing shown is form tools. Is it too mundane to talk about data validation? In a cell, sans vba, you choose from a list, between to values, or formulaic approach. Doesn’t that control a worksheet for someone doing data entry?
The article should be entitled controls on worksheet using form tools.
Hi Kevin,
The article focusses on the form controls, I’ll add a remark on the data validation though.
Thanks!