I am trying to create a form in Excel that when info is entered into it
populates a table in another worksheet.

When you say 'Form' do you mean a user form (gray dialog-like form with
fields and buttons, doesn't look like an Excel sheet at all) or do you mean a
specially laid out Excel worksheet set up just to gather the data from the
user?

If it is a user form that you desire, go into the VB Editor ( use
[Alt]+[F11] to open it) and choose Insert | UserForm to begin creating one.
If you've never created one of those before it can be a little confusing. Do
some reading in the Help files about working with them. Big questions about
them seem to be
"where do I put the code to make them do things?" and
"how do I get it in view so I can use it?"

For the second question the answer is that you use something on a sheet
(either a button or an action) to execute a one-line command
myUserForm.Show
where myUserForm is the name of the form you created. That brings the form
into view for use.

The answer to the first question is that the code is set up/created by
right-clicking on the user form in design mode and choosing View Code - you
can switch back and forth between View Code and View Object to design and
develop the form.

"Majik" wrote:

I am trying to create a form in Excel that when info is entered into it
populates a table in another worksheet.