[Terrie L]

Graham,
Thank you for your response re setting up my school reports. Whilst
confident on a computer, I am nowhere in your league :-)
However I managed to set up the classic form controls in my word document...
and yes, this way is much easier to use than the newer version. I am really
interested in your method of creating a drop down menu from 1-21, and
running a macro on exit so that (if I understand correctly) the table of 21
columns will shade in in a way corresponding to the number indicated in the
drop down menu. Do I understand that clearly?
One little problem... I have heard of macros, but never run one. As an ICT
teacher at a primary (elementary) school in Australia, I have never needed to
use them. However I am always looking for ways to provide my own professional
development. Is it too hard for you to explain to me how to do it?
If you need to be refreshed on my situation, my original post was 9/13/08
titled forms in word
Many thanks for your suggestions already and hoping you can help me further,
Terrie

[Graham Mayor]

Yes you understand it clearly. Your original post prompted me to create an
additional entry to my web site - see the last item at
http://www.gmayor.com/word_vba_examples.htm However I have used only 10
entries and not 21 in the example. You can read it in conjunction with
http://www.gmayor.com/installing_macro.htm. If that is what you had in mind
it is relatively simple to extend it to 21 columns.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Terrie L wrote:
Graham,
Thank you for your response re setting up my school reports. Whilst
confident on a computer, I am nowhere in your league :-)
However I managed to set up the classic form controls in my word
document... and yes, this way is much easier to use than the newer
version. I am really interested in your method of creating a drop
down menu from 1-21, and running a macro on exit so that (if I
understand correctly) the table of 21 columns will shade in in a way
corresponding to the number indicated in the drop down menu. Do I
understand that clearly?
One little problem... I have heard of macros, but never run one. As
an ICT teacher at a primary (elementary) school in Australia, I have
never needed to use them. However I am always looking for ways to
provide my own professional development. Is it too hard for you to
explain to me how to do it?
If you need to be refreshed on my situation, my original post was
9/13/08 titled forms in word
Many thanks for your suggestions already and hoping you can help me
further, Terrie