Melody, let me rephrase to see if I understand you correctly. You have
information on a worksheet that you would like users to modify with a form.
The form can read data from the worksheet(s) when it opens (or refreshes),
allow the user to modify in the form, and save the modified data back to the
worksheet. Is this what you would like? Can you describe more about the
type of data (single items, a one-dimensional list of values, a two-dimension
table of values, etc.).

Regards,
Bill

"Melody" wrote:

I have developed a form in Excel and would like when filling in the form that
it would update a database in Excel or vice versa. Is this possible in
Excel?