Input Screen
 

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?

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).

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Chandra" wrote in message
...
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?

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?

"Earl Kiosterud" wrote:

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).

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Chandra" wrote in message
...
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?

Debra Dalgleish has a getstarted with userforms at:
http://www.contextures.com/xlUserForm01.html



Chandra wrote:

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?

"Earl Kiosterud" wrote:

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).

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Chandra" wrote in message
...
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?




--

Dave Peterson