Thread: Data entry using a userform

Hi

I am developing a production scheduling application.
The basic information is derived from our Order entry program by means of an ODBC link.
For scheduling purposes further information has to be added. I was hoping to use a UserForm
with, one by one, each record populated with data from the linked table, and with empty textboxes to be filled in manualy by the scheduler. I could do this in Access but am stumped in Excel.
(I need Excel for all the manipulation needed afterwards) can anyone help please

John Southern

How about some on-line examples:

http://www.contextures.com/xluserform01.html

http://www.contextures.com/xluserform02.html

Hi Jeffrey,
Thank you for pointing me in the right direction. I can now get started. What I actually want to do is a bit more complicated than suggested in my original post. I need to be able to populate some of the fields on the form with records in the table, and then fill some other fields which are empty. Then move on to the next partly filled record. I'll have a go myself though and come back to the forum if I fail.
John

Hi John,

Glad it helped get you started.

Here is another resource which may or may not help.

http://spreadsheetpage.com/index.php/dataform/home