#1
|
|||
|
|||
I am not a VBScript person
I have never done any VBScript before, never needed to. But I kinda do now.
I have a word document 2016 with 6 drop-down menu content controls, title/labels A, B, C, D, E, F. Each drop down contains these options, values: Poor, 1 Fair, 2 Satisfactory, 3 Good, 4 Excellent, 5 Each field is neutral when loading, "Please select a value" I have a field at bottom I want to have average the values from the 6 dropdowns as they are visited: ((valueA + valueB + valueC +valueD +valueE +valueF)/(number visited)) This is better as a variable: ((totalScore)/(numVisited)) entryValue: [userselected]; global: totalScore: 0; global: numVisited:0; After a user selects an option, I want the field to evaluate the selection, use its numerical value to update the totalScore and numVisited variables used for the average, and display the average. onExit {If (entryValue= "Poor") { entryValue+=1; } else if (entryValue = "Fair") { entryValue+=2; } else if (entryValue = "Satisfactory") { entryValue+=3; } else if (entryValue = "Good") { entryValue+=4; } else { entryValue+=5; } numVisited+=1; totalScore+=entryValue; } I don't know vb, though, and I need some help writing the code for this, and I need to know what field type to use for the average field. Thank you in advance! -TiaTheTechWriter |
#2
|
||||
|
||||
Can you load a sample document with the necessary CCs? Where does number visited come from? Is it the number out of the a-f fields that have been completed?
And you are after VBA not VBScript - there is subtle differences.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#3
|
||||
|
||||
The attached should give you a few ideas
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#4
|
|||
|
|||
Quote:
I considered doing it as a sharepoint page, but there are other concerns there. |
#5
|
|||
|
|||
I actually ended up creating it in InfoPath and publishing it to a network share with email submission. Turned out pretty nifty there, if I do say so myself! Thanks, all!
|
Tags |
average, dropdowns, vb |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook 2010 VBScript - error: forward a custom form | Berg | Outlook | 0 | 08-31-2015 10:10 AM |
VBScript - outlook does not recognize one or more recipients | johnc83 | Outlook | 1 | 07-16-2015 06:42 AM |
VBScript.RegExp: exclude a particular word | tinfanide | Excel Programming | 2 | 06-07-2012 06:52 AM |
.doc Suddenly Changed to .vbe (VBScript Encoded Script File) | emes | Word | 2 | 04-24-2012 05:07 PM |
VbScript to Print a .pdf | DaveB | Excel | 2 | 03-07-2009 12:36 PM |