PC Review


Reply
Thread Tools Rating: Thread Rating: 1 votes, 5.00 average.

RADIO BUTTON LINKS SWITCHING BACK TO NUMBER

 
 
New Member
Join Date: May 2012
Posts: 6
 
      14th May 2012
I have just finished creating a multiple choice test sheet using radio buttons. The answers to each of the questions is in the form of a letter, A,B,C or D. I would have it all set up the way I want, save it, then close and open the worksheet again, and all the letters turn back to numbers. How do I get it so the answers will stay in letter form. That is how my point system is based right now. It is 1 point for each correct answer and the answers are transferred to another Workbook with a Worksheet entitled IST ANSWER SHEET, In there the answers are also listed with the correct letter to each question and when the programming compares the correct ones with the ones from the TEST worksheet, it will result in a percentage. Since I cannot seem to attach the actual excel sheet, I have included the Question 1 and 2 radio buttons. I have 25 questions with only 1 of the questions having a True or False answer in the form of letter A or B.

Sub HideAllGroupBoxes()
Dim Sh As Worksheet
Dim gBox As GroupBox
Set Sh = ActiveSheet
For Each gBox In Sh.GroupBoxes
gBox.Visible = False
Next gBox
End Sub

Sub Button_1A()
ActiveSheet.Shapes("1A").Select
Range("K18").Select
ActiveCell.FormulaR1C1 = "A"

End Sub

Sub Button_1B()
ActiveSheet.Shapes("1B").Select
Range("K18").Select
ActiveCell.FormulaR1C1 = "B"

End Sub
Sub Button_1C()
ActiveSheet.Shapes("1C").Select
Range("K18").Select
ActiveCell.FormulaR1C1 = "C"

End Sub
Sub Button_1D()
ActiveSheet.Shapes("1D").Select
Range("K18").Select
ActiveCell.FormulaR1C1 = "D"

End Sub
Sub Button_2A()
ActiveSheet.Shapes("2A").Select
Range("K25").Select
ActiveCell.FormulaR1C1 = "A"

End Sub

Sub Button_2B()
ActiveSheet.Shapes("2B").Select
Range("K25").Select
ActiveCell.FormulaR1C1 = "B"

End Sub
Sub Button_2C()
ActiveSheet.Shapes("2C").Select
Range("K25").Select
ActiveCell.FormulaR1C1 = "C"

End Sub
Sub Button_2D()
ActiveSheet.Shapes("2D").Select
Range("K25").Select
ActiveCell.FormulaR1C1 = "D"

End Sub
 
Reply With Quote
 
 
 
 
New Member
Join Date: May 2012
Posts: 6
 
      14th May 2012
I have converted the IST TEST worksheet to pdf format so anyone who can help can see how everything is laid in relation to the code.
Attached Files
File Type: pdf IST TEST.pdf (24.6 KB, 96 views)
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ASP.NET Reset Radio Button in a group of Radio Buttons Scott D Johnson Microsoft ASP .NET 1 27th Sep 2006 11:38 PM
Links in IE keep switching back to Alphabetical order on their own. tomfrazier@gmail.com Windows XP Internet Explorer 2 8th Apr 2006 01:38 AM
disable the back button provide the users with my own button to go back. sylvia sil Microsoft ASP .NET 1 29th Dec 2004 05:41 PM
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True Mcasteel Microsoft Excel Worksheet Functions 2 29th Oct 2004 07:06 PM
How do I get radio stations, how do I get "radio tuner"? Windows XP Music 2 2nd Nov 2003 12:41 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:30 AM.