Produce an Excel Userform to collect user input
$65
Delivery in
3 days
- Views 690
Amount of days required to complete work for this Offer as set by the freelancer.
Rating of the Offer as calculated from other buyers' reviews.
Average time for the freelancer to first reply on the workstream after purchase or contact on this Offer.
Explore the marketplace!
What you get with this Offer
I can produce a VBA macro for Excel consisting of a Userform that accepts user input. It can contain up to 12 data fields, e.g. text, drop downs, list boxes, radio buttons or check boxes. Lists can take their input from a location within the spreadsheet. Once collected, the data will be copied to a spreadsheet on the next empty row. Each data item can be verified, if the verification rules are specified. The form can include a "Next" button to copy the data, clear itself, and be ready for more input. If more fields are required beyond the 12, it would need to be posted as a full project.
What the Freelancer needs to start the work
I would need the spreadsheet that you want to populate and details of the data fields you need to collect and any rules for verifying that data. If you have a preference for how to trigger the macro and open the userform, such as a shortcut key, button or custom tab on the ribbon, I would need that as well.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies