|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need macro for automatic point value insertion based on the number of answer choices selected
I need the macro to insert/select the Point Values automatically based on the number of answer choices selected.
Point Values contain the values in Drop-down List Content Control as 01, 02, 03, 04, 05, 06. When i select the answer(s) as "X" (which is styled as "Correct Answers"), automatically select the point value from the Drop-down control. Please can anyone help me out on this? |
#2
|
||||
|
||||
You'll need to supply a document with some content demonstrating your requirements. You can attach a document to a post via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
example doc attached...
|
#4
|
||||
|
||||
I don't see any reference to your 01, 02, 03, 04, 05, 06 in the attachment (as either the dropdown display text or values), so it's not apparent how those function.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Revised file attached. The drop-down control automatically select the values based on the number of "X"s selected from the answer choice.
if "X" value is = 01 if "X" "X" = 02 etc... Kindly let me know if anything need. |
#6
|
||||
|
||||
There's no attachment to your latest post, and your previous attachment appears unchanged.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
Sorry i forgot to select Upload option...
|
#8
|
||||
|
||||
So how do the 'Correct Answer' selections relate to the 'Total Points' and why do you need a dropdown for what should presumably be a fixed value?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#9
|
|||
|
|||
"Correct Answer" selection is do manually, based on the questions, so the point value no need to put in the drop-down.
I need only to display the point value (either 01, 02, 03, 04, 05, 06) maximum requirement is 06, based on the number "X"s selected. It is select either as one's or multiple times based on the questions. |
#10
|
||||
|
||||
But there's only 4 possible 'Correct Answer' selections...
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#11
|
|||
|
|||
The sample attachment is having only the four answer choices. Sometimes it will extend up to 6 choices based on the questions.
|
#12
|
||||
|
||||
Try the attached. Note that I've replaced your 'Total Points' dropdown with a plain text one titled 'Total'.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#13
|
|||
|
|||
Superb!!!!
But i need the code please.... |
#14
|
||||
|
||||
It's in the document... Press Alt-F11 to open the VBA Editor.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#15
|
|||
|
|||
oh
Fantastic!!!! Thank much!!! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cursor location on first click -- insertion point | stevec5088 | Word | 1 | 12-14-2016 02:45 PM |
Move Insertion Point with VBA | Grasor | Word VBA | 2 | 10-11-2016 08:50 PM |
Need macro to fill data from different sheets based on selected item from drop down | skorasika | Excel Programming | 1 | 03-13-2015 11:25 AM |
Populate a table based on choices from drop down menu | Xaand | Word VBA | 0 | 02-25-2014 11:08 AM |
Insertion point not working | pmahoney14 | Word | 1 | 05-24-2012 04:17 PM |