Data Input Screen

  • Thread starter Thread starter P. Balmanno
  • Start date Start date
P

P. Balmanno

Ok, Excel isn't a data base but I like the way I can manipulate data to do
graphs and cut and paste what I need for query tables. Now, what I like to
know is if there is a site that will instruct on creating data input
screens. Eventually my work book will require one for data entry and at
least one for query output. I would appreciate the help - I read
instructions well - meaning I'm not looking for a quick answer but a useful
site with info on how to. TIA
 
Hi
maybe the following is what you're looking for:
http://j-walk.com/ss/dataform/index.htm

--
Regards
Frank Kabel
Frankfurt, Germany


P. Balmanno said:
Ok, Excel isn't a data base but I like the way I can manipulate data
to do graphs and cut and paste what I need for query tables. Now,
what I like to know is if there is a site that will instruct on
creating data input screens. Eventually my work book will require
one for data entry and at least one for query output. I would
appreciate the help - I read instructions well - meaning I'm not
looking for a quick answer but a useful site with info on how to.
Click to expand...
TIA
 
Hi

This is a quick (but hopefully useful) answer:

Excel has a built-in Data Input Screen:

Data/Form

As long as you have all the Row and Column headings in
place, you can use this to enter, change or delete data.

regards
Hans
 
Thanks, but I was looking for more the tutorial type of how too. I guess I
would need VBA to create the form. I did some VB programming before so I
will look at something in that realm. Thanks again.
 
Yes I've seen this feature but I wanted some direction in tutorials on how
to customize it. Also I need a query form for report outputs that would
include printing out a graph. I think VBA may be the route I need instead
of the default form, unless it's a matter of my learning how to modify it.
 
Back
Top