I built a financial model in Excel, which uses several product inputs and
then calculates various profit scenarios.
I now wish to make it easier for users to use the model by:
(i) Building lists for product data to be stored (in the background)
(ii) Adding user forms, so that users do not manipulate lists directly.

I am familiar with lists, and know of the Data-Form command, which generates
a plain form. However, I need to generate a customised form, with the
company logo and some data validation.

I managed to design the front-end of the form, by dragging controls into the
worksheet area, but am unsure as to how to link the form to the list (i.e.:
when the user enters data into the form, the list is updated).

Can anyone help?