amitkumarson
01-27-2012, 06:43 AM
I want to make a macro like KBC Game, I've attached the files for reference.
1.) User Interface (User Interface will show to end users.)
a.) Main Sheet (WorkSheet)
i.) Questions should be shown randomly
ii.) According to the question the serial no. & Options should be changed
iii.) When user clicks on Next button, it will show the next random question.
iv.) When user click on Back button, it will show the last question.
b.) Questions (WorkSheet)
i.) Questions will be store in this sheet.
2.) Control Panel
a.) Add More Question(Command Button)
i.) When I will click on this button it will show a form. (I've already make that form)
ii.) When I will click on "Add" button on the "Add Questions" form, it should add the questions in "User Interface" file from the given file's path.
b.) Remove Previous Questions(Command Button)
i.) All questions which are stored in "User Interface" file should be shown in "List Box"
ii.) I can multi select questions & when clicked on the "Remove Selected" button, it should remove the selected question from the "User Interface" file.
1.) User Interface (User Interface will show to end users.)
a.) Main Sheet (WorkSheet)
i.) Questions should be shown randomly
ii.) According to the question the serial no. & Options should be changed
iii.) When user clicks on Next button, it will show the next random question.
iv.) When user click on Back button, it will show the last question.
b.) Questions (WorkSheet)
i.) Questions will be store in this sheet.
2.) Control Panel
a.) Add More Question(Command Button)
i.) When I will click on this button it will show a form. (I've already make that form)
ii.) When I will click on "Add" button on the "Add Questions" form, it should add the questions in "User Interface" file from the given file's path.
b.) Remove Previous Questions(Command Button)
i.) All questions which are stored in "User Interface" file should be shown in "List Box"
ii.) I can multi select questions & when clicked on the "Remove Selected" button, it should remove the selected question from the "User Interface" file.