Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-31-2018, 05:23 AM
ganesang ganesang is offline Need macro for automatic point value insertion based on the number of answer choices selected Windows XP Need macro for automatic point value insertion based on the number of answer choices selected Office 2016
Competent Performer
Need macro for automatic point value insertion based on the number of answer choices selected
 
Join Date: Jul 2018
Posts: 171
ganesang is on a distinguished road
Exclamation 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?
Reply With Quote
  #2  
Old 07-31-2018, 06:13 AM
macropod's Avatar
macropod macropod is offline Need macro for automatic point value insertion based on the number of answer choices selected Windows 7 64bit Need macro for automatic point value insertion based on the number of answer choices selected Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 07-31-2018, 06:18 AM
ganesang ganesang is offline Need macro for automatic point value insertion based on the number of answer choices selected Windows XP Need macro for automatic point value insertion based on the number of answer choices selected Office 2016
Competent Performer
Need macro for automatic point value insertion based on the number of answer choices selected
 
Join Date: Jul 2018
Posts: 171
ganesang is on a distinguished road
Default

example doc attached...
Attached Files
File Type: docx example_doc.docx (21.4 KB, 10 views)
Reply With Quote
  #4  
Old 07-31-2018, 06:56 AM
macropod's Avatar
macropod macropod is offline Need macro for automatic point value insertion based on the number of answer choices selected Windows 7 64bit Need macro for automatic point value insertion based on the number of answer choices selected Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #5  
Old 07-31-2018, 09:41 PM
ganesang ganesang is offline Need macro for automatic point value insertion based on the number of answer choices selected Windows XP Need macro for automatic point value insertion based on the number of answer choices selected Office 2016
Competent Performer
Need macro for automatic point value insertion based on the number of answer choices selected
 
Join Date: Jul 2018
Posts: 171
ganesang is on a distinguished road
Post

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.
Reply With Quote
  #6  
Old 07-31-2018, 10:23 PM
macropod's Avatar
macropod macropod is offline Need macro for automatic point value insertion based on the number of answer choices selected Windows 7 64bit Need macro for automatic point value insertion based on the number of answer choices selected Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

There's no attachment to your latest post, and your previous attachment appears unchanged.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 07-31-2018, 10:26 PM
ganesang ganesang is offline Need macro for automatic point value insertion based on the number of answer choices selected Windows XP Need macro for automatic point value insertion based on the number of answer choices selected Office 2016
Competent Performer
Need macro for automatic point value insertion based on the number of answer choices selected
 
Join Date: Jul 2018
Posts: 171
ganesang is on a distinguished road
Post

Sorry i forgot to select Upload option...
Attached Files
File Type: docx example_doc.docx (22.9 KB, 7 views)
Reply With Quote
  #8  
Old 07-31-2018, 10:29 PM
macropod's Avatar
macropod macropod is offline Need macro for automatic point value insertion based on the number of answer choices selected Windows 7 64bit Need macro for automatic point value insertion based on the number of answer choices selected Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #9  
Old 07-31-2018, 10:35 PM
ganesang ganesang is offline Need macro for automatic point value insertion based on the number of answer choices selected Windows XP Need macro for automatic point value insertion based on the number of answer choices selected Office 2016
Competent Performer
Need macro for automatic point value insertion based on the number of answer choices selected
 
Join Date: Jul 2018
Posts: 171
ganesang is on a distinguished road
Default

"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.
Reply With Quote
  #10  
Old 07-31-2018, 10:37 PM
macropod's Avatar
macropod macropod is offline Need macro for automatic point value insertion based on the number of answer choices selected Windows 7 64bit Need macro for automatic point value insertion based on the number of answer choices selected Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

But there's only 4 possible 'Correct Answer' selections...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #11  
Old 07-31-2018, 10:38 PM
ganesang ganesang is offline Need macro for automatic point value insertion based on the number of answer choices selected Windows XP Need macro for automatic point value insertion based on the number of answer choices selected Office 2016
Competent Performer
Need macro for automatic point value insertion based on the number of answer choices selected
 
Join Date: Jul 2018
Posts: 171
ganesang is on a distinguished road
Default

The sample attachment is having only the four answer choices. Sometimes it will extend up to 6 choices based on the questions.
Reply With Quote
  #12  
Old 07-31-2018, 11:02 PM
macropod's Avatar
macropod macropod is offline Need macro for automatic point value insertion based on the number of answer choices selected Windows 7 64bit Need macro for automatic point value insertion based on the number of answer choices selected Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Try the attached. Note that I've replaced your 'Total Points' dropdown with a plain text one titled 'Total'.
Attached Files
File Type: docm Example.docm (33.6 KB, 19 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #13  
Old 07-31-2018, 11:06 PM
ganesang ganesang is offline Need macro for automatic point value insertion based on the number of answer choices selected Windows XP Need macro for automatic point value insertion based on the number of answer choices selected Office 2016
Competent Performer
Need macro for automatic point value insertion based on the number of answer choices selected
 
Join Date: Jul 2018
Posts: 171
ganesang is on a distinguished road
Default

Superb!!!!

But i need the code please....
Reply With Quote
  #14  
Old 07-31-2018, 11:07 PM
macropod's Avatar
macropod macropod is offline Need macro for automatic point value insertion based on the number of answer choices selected Windows 7 64bit Need macro for automatic point value insertion based on the number of answer choices selected Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

It's in the document... Press Alt-F11 to open the VBA Editor.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #15  
Old 07-31-2018, 11:09 PM
ganesang ganesang is offline Need macro for automatic point value insertion based on the number of answer choices selected Windows XP Need macro for automatic point value insertion based on the number of answer choices selected Office 2016
Competent Performer
Need macro for automatic point value insertion based on the number of answer choices selected
 
Join Date: Jul 2018
Posts: 171
ganesang is on a distinguished road
Default

oh

Fantastic!!!!

Thank much!!!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need macro for automatic point value insertion based on the number of answer choices selected Cursor location on first click -- insertion point stevec5088 Word 1 12-14-2016 02:45 PM
Need macro for automatic point value insertion based on the number of answer choices selected 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
Need macro for automatic point value insertion based on the number of answer choices selected Insertion point not working pmahoney14 Word 1 05-24-2012 04:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:16 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft