Auto fill in forms

[T]

I am creating a form whereby applicants will need to check a box next to a
set of criteria, and then points assessed to those criteria will be applied.
I would like to automate this by setting it up so that when the box is
selected, a check mark(or some symbol) is filled in and associated points
for that line would be activated in a separate column, and then points
totaled at specific locations in the column (subtotaled or grand totaled).

The end users will likely be using Excel 2003, and may not likely have
Access available. I know Excel can do wondrous things, but I don’t know
where to start looking. Can anyone point me in the right direction?
Thanks

 

[Bob Bridges]

To tell you the truth, I too am more familiar with Access forms than Excel.
But I know Excel can do this sort of thing, and I can maybe point you in the
right direction.

Let's start here: You posted this in the "Excel Worksheet Functions" forum,
but if you're going to do forms then you should transfer this question to the
"Excel Programming" forum. That's where they talk about VBA solutions.

Second, check out the CHM file that pertains to VBA/Excel; there's a section
in there on VBA forms. I can't swear to where you'll find it on your
machine, but on mine it was at "C:\Program Files\Microsoft Office XP
Standard\Office10\1033\VBAXL10.CHM". Personally I recommend doing a search
on all *.CHM documents under your C:\Program Files and go through them,
making a shortcut to each one that looks useful -- at least, if you're going
to do much programming I would. There are extensive manuals on VBA for all
the Office apps (including some I didn't know existed), for HTML documents,
for ADO and DAO, for JScript, for Jet SQL, for VBS and various VBS tools,
lots of things.

If you're already familiar with creating and programming forms in Access,
this may be all you need to get started, barring a few of the differences in
the Excel interface. For that, as I said, you should post further questions
in the Excel Programming forum.

 

[T]

Thanks Bob
--
T

To tell you the truth, I too am more familiar with Access forms than Excel.
But I know Excel can do this sort of thing, and I can maybe point you in the
right direction.

Let's start here: You posted this in the "Excel Worksheet Functions" forum,
but if you're going to do forms then you should transfer this question to the
"Excel Programming" forum. That's where they talk about VBA solutions.

Second, check out the CHM file that pertains to VBA/Excel; there's a section
in there on VBA forms. I can't swear to where you'll find it on your
machine, but on mine it was at "C:\Program Files\Microsoft Office XP
Standard\Office10\1033\VBAXL10.CHM". Personally I recommend doing a search
on all *.CHM documents under your C:\Program Files and go through them,
making a shortcut to each one that looks useful -- at least, if you're going
to do much programming I would. There are extensive manuals on VBA for all
the Office apps (including some I didn't know existed), for HTML documents,
for ADO and DAO, for JScript, for Jet SQL, for VBS and various VBS tools,
lots of things.

If you're already familiar with creating and programming forms in Access,
this may be all you need to get started, barring a few of the differences in
the Excel interface. For that, as I said, you should post further questions
in the Excel Programming forum.