Hello all,
I am trying to create an excel VBA userform which has a few details that are input using textboxes like "Student Name", "Student Address", Student contact number" etc. This form also contains several questions for which the user is supposed to select one of the 5 optionbuttons coressponding to wach question which are placed in a container frame.
There is a command button to save the input from the userform to the next excel sheet tab.
I am using the following piece of code:
The above piece of code is working. However I am not sure how to save the data from the chosen optionbutton in excel sheet.
Please help this newbie out!
I am trying to create an excel VBA userform which has a few details that are input using textboxes like "Student Name", "Student Address", Student contact number" etc. This form also contains several questions for which the user is supposed to select one of the 5 optionbuttons coressponding to wach question which are placed in a container frame.
There is a command button to save the input from the userform to the next excel sheet tab.
I am using the following piece of code:
Code:
Set ws = Worksheets("Data")
irow = ws.Cells(Rows.count, 1).End(xlUp).Offset(1, 0).Row
With ws
.Range("A" & irow) = TextBox5.Value
.Range("B" & irow) = TextBox6.Value
The above piece of code is working. However I am not sure how to save the data from the chosen optionbutton in excel sheet.
Please help this newbie out!