Extreme beginner Question

[Jim]

I have my back end of the database done, I want to be able
to create a user-friendly prompt that asks for the
information that needs to be imported into the table. For
instance if i have an employee tab, that contains employee
name, job title, start date, etc.... can i create a prompt
that pops up asking the user for the name, title, start
date, and then places it in the appropriate location (the
first free row) in the table, instead of having them go
into the table and finding the last entry and then
inputting that way? Thank a lot for your help.

Any guidance would be great, where to look for more info,
anything....thanks

 

[kkknie]

This could be simple, or not so simple. To get you started, here's
link to a pretty large list of Excel Help links.

http://www.mvps.org/dmcritchie/excel/excel.htm

Here's the general way to handle it:

1. Create a userform in the VB Editor.
2. Put text boxes, labels, comboboxes, etc. on it.
3. Show the userform (either on opening the workbook or with a butto
from a sheet.
4. After the user enters all of the info, search for the correct place
on the sheets and insert the data.

Post back with questions and I'll try to guide you.

 

[Frank Kabel]

Hi
you may have a look at
http://j-walk.com/ss/dataform/index.htmhttp://j-walk.com/ss/dataform/in
dex.htm