Goto Option_Button; Calculations; Auto-update; Even Colors!

[TomorrowsMan]

I've got what is probably not a terribly hard bit here, but I'm still
very new to VBA in Word and I'm stumped. Here's what I would like to
be able to do:

I have a Word 2000 form that has several rows of rating criteria; the
ratings are from 1-4. Managers have eight (8) criteria to be rated,
while non-managers have five (5). I have put in a userform with two
option buttons and the question "Is this a manager review?" I am
trying to figure out how to:

Have the Yes/No option button selection in the Userform go to a slider bar (scrollbar1) if the user selects "Yes," or go to a different bookmark on the next page (scrollbar4) if the answer is "No."

This part has been stumping me, but the next part is even dodgier --
after the user is done selecting the eight or five ratings, I need the
form to auto-calculate the overall rating...which would be divided by 8
for a manager, or 5 for a non-manager. I could knock this out in
Excel, but scripting formulas and fields in Word is a whole 'nuther
ball of wax for me so far.

These are my big barriers right now.

Thanks!

_________________________________________________


P.S.: Since i'm new at this and this is a spectacular forum, I've got
two other small bits I haven't cracked yet -- I'm currently browsing
the usergroups for:

1. How to have form fields calculate automatically even if fill-in is
disabled (e.g., the Manager's rating subtotal, criteria 1-3);

and, much more extravagantly...

2. How I could have the value of a slider bar change the color in a
corresponding cell (not even sure if this is possible, but the way the
criteria are set up, the slider bar is what chooses the rating of 1, 2,
3, or 4. As the user slides the bar over, I would love if the
corresponding table cell above the slider -- which is basically just a
text field with "1.0" "2,0" etc. in it -- would highlight to easily
display what value is currently selected.

Cheers,
TMan

 

[Cindy M -WordMVP-]

Hi TomorrowsMan,

Not sure if you're still around, or still looking for help on this?

I suspect the reason I don't see any replies, here, is that no one is quite sure
where you're starting from. By "form" do you mean a form with form field? With
ActiveX controls from the Control Toolbox? Or a UserForm (VBA dialog box)? The
option buttons appear to be on a UserForm, but is everything else to which you
refer also on the UserForm?

What "sliderbars/scrollbars"? A UserForm can't have a bookmark, so apparently at
least part of this is in a Word document...

I've got what is probably not a terribly hard bit here, but I'm still
very new to VBA in Word and I'm stumped. Here's what I would like to
be able to do:

I have a Word 2000 form that has several rows of rating criteria; the
ratings are from 1-4. Managers have eight (8) criteria to be rated,
while non-managers have five (5). I have put in a userform with two
option buttons and the question "Is this a manager review?" I am
trying to figure out how to:

(scrollbar1) if the user selects "Yes," or go to a different bookmark on the next
page (scrollbar4) if the answer is "No."

This part has been stumping me, but the next part is even dodgier --
after the user is done selecting the eight or five ratings, I need the
form to auto-calculate the overall rating...which would be divided by 8
for a manager, or 5 for a non-manager. I could knock this out in
Excel, but scripting formulas and fields in Word is a whole 'nuther
ball of wax for me so far.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply in
the newsgroup and not by e-mail