Checkboxes to tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Angyl - 09 Nov 2007 20:33 GMT

The problem: People in my company fill out surveys in Word. The surveys ask
for ratings from 1-5 on certain questions and they use checkboxes to select
the appropriate answer. All of this data later has to be entered later (by
me) into Excel.

My request:
The VBA code (and I'm fairly certain this would be possible) so that if
saaaay, chkBox2 is checked, then a table in the document will put a "2" in a
certain field.

So how would I write something like:

chkBox2 if checked with ActiveDocument.table1 row 1 cell 4 = 2

This'll save me HOURS of work in the future, thanks!

Reply to this Message

Doug Robbins - Word MVP - 09 Nov 2007 21:08 GMT

I suggest that you take a look at the following page of fellow MVP Dian
Chapman's website:

http://www.mousetrax.com/techpage.html#autoforms

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> The problem: People in my company fill out surveys in Word. The surveys
> ask
[quoted text clipped - 15 lines]
>
> This'll save me HOURS of work in the future, thanks!

Reply to this Message

Angyl - 09 Nov 2007 21:27 GMT

Wow... that looks like a WAY COOL site for learning how to do lots of little
things. THANKS!

however, the solution provided for exporting data to Excel won't work in my
situation because the spreadsheet I'm working with is a "working" sheet, that
is to say it's growing and changing all the time and no computer is going to
be able to determine properly which worksheet/row to automatically
export/import data to.

A copy/paste from a Word table to Excel still seems like the best/only way.

> I suggest that you take a look at the following page of fellow MVP Dian
> Chapman's website:
[quoted text clipped - 20 lines]
> >
> > This'll save me HOURS of work in the future, thanks!

Reply to this Message

Doug Robbins - Word MVP - 10 Nov 2007 06:09 GMT

If it's the next row, I think that you underestimate the ability of a
computer/macro designer.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Wow... that looks like a WAY COOL site for learning how to do lots of
> little
[quoted text clipped - 38 lines]
>> >
>> > This'll save me HOURS of work in the future, thanks!

Reply to this Message