school test maker

ENEMALI

Board Regular
Joined
Aug 9, 2011
Messages
60
I know this isn't a forum for ms word but I believe some one can assist me.
I'm trying to type so many multiple choice questuions in ms word not very fast in typing and repeated formatting of the documents consumes time.
So I did this, I created a userform in ms word then inserted six TextBox. TextBox1 is for question and TextBox2 to TextBox6 are for the optional answers A to E .
Two commandButton are on the userform
Commandbutton1 is ENTER
Commandbutton2 is UNDUE

There are also two checkbox on the form
One is called horizontal and the 2nd is called
vertical.
This is what I want to achieve
If I type any question in texbox1 and the optional answers in textbox2 to 6, then hit the enter key on keyboard or mouse click enter button on the form, the question and its options should be fed to the document and the userform cleared for the next question and when the undue is clicked,this takes me back to previous quetion .
Also if horizontal checkbox is checked the optional answers(A-E) should be arranged horizontaly or verticaly when the vertical checkbox is checked. I want automatic numering of question typing of the letter A. B. C. D. E. Of the multiple choice shouldn't be manual but automatic from the form.
Any assistance and suggestion is greatly appreciated.
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
If you're using Word 2007 or later, you could define a custom Quick Part Consisting of an empty table with, say, a row for the question and four or five rows for the answers. You might have two columns, the first one having a SEQ field or an auto numbered paragraph for automatically generating the Question numbers on the first row and letters in the rows below for the answer options. no vba would be required for this.
 
Upvote 0
Thanks macropod I will give it a try and give you a feed back even though I have little idea on your reply
 
Upvote 0

Forum statistics

Threads
1,225,625
Messages
6,186,074
Members
453,336
Latest member
Excelnoob223

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top