Input Screen

C

Chandra

I've seen a spreadsheet made for data input where ther was a input screen,
similar to the ones you can design in Access, but I don't know how to create
and input screen. Can onyone help me?
 
E

Earl Kiosterud

Chandra,

If you're entering into a table, take a look at Data - Form. Your table
needs headings. If you want a custom-made input form, you do that in Visual
Basic, and have to write code to handle the things the user does in your
form (like put the stuff into a sheet, etc).
 
C

Chandra

Thank you, that was very helpful. I have now figured out what you're
referring to with Visual Basic, I just don't know how to assign a text box to
go to a particular column. Doesn that make sense?
 
Top