4 May 2017
You can give your worksheets form-like functionality without ever having to use VBA. In order to achieve this, you will have to use form controls.
Using formulas in combination with form controls, one can further extend the form control functionality and form-like appearance of the worksheet at hand.
This article uses a few simple examples to illustrate how to use form controls in Excel.
Full article: How to use form controls in Excel