I created a dialogue box with 3 option buttons in order to change between result and answers target, but there are wrong array results after code. Why and how to solve it? thanks
Private Sub RunTestCommandButton_Click()
'result is target for table
If OptionButton1.Value = True Then
Range("result") = Range("ans_A") 'ans_A is answer from equation A f(x,y)
ElseIf OptionButton2.Value = True Then
Range("result") = Range("ans_B") 'ans_B is answer from equation B f(x,y)
ElseIf OptionButton3.Value = True Then
Range("result") = Range("ans_C") 'ans_C is answer from equation C f(x,y)
End If
Range("table").Select 'table is data table for array results by parameters
Selection.Table RowInput:=Range("x"), ColumnInput:=Range("y") 'x and y are parameters for equation A, B & C f(x,y)
Calculate
Bookmarks