Spreadsheet as data entry form

I wish to use some of my excell files as dataforms so I will have all
information straight away in database, are there any good ways to do
such a thing or my idea is crazy ?

regards
Peter

Hi Peter

my "database" do you mean in excel or in a database program?
either can be achieved (although i've not had much experience with writing
from excel to a database).
if you mean a database (ie flat file - records running across rows and the
fields in columns) in excel, then one place to start is to create your
"database" (put the headings in row 1) and then as long as you've got less
than 30 columns you can use data / form from the menu.

if you'ld like to provide additional information i'm sure we can come up
with other ideas for you - most, however, will probably involve some VBA.
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Piotr" <hokah@wp.pl> wrote in message
news:af2bdc1c.0504110022.3f6f190f@posting.google.com...
>I wish to use some of my excell files as dataforms so I will have all
> information straight away in database, are there any good ways to do
> such a thing or my idea is crazy ?
>
> regards
> Peter

And if JulieD's suggestion of Data|Form isn't sufficient, maybe you could use
John Walkenbach's enhanced data form:
http://j-walk.com/ss/dataform/index.htm

Debra Dalgleish has some get started with userforms notes at:
http://www.contextures.com/xlUserForm01.html

If you want to write your own.


Piotr wrote:
>
> I wish to use some of my excell files as dataforms so I will have all
> information straight away in database, are there any good ways to do
> such a thing or my idea is crazy ?
>
> regards
> Peter

--

Dave Peterson