VBA User Form - Option Button

[nivassrii]

Dear Friends,

I need some help regarding the option buttons created in VBA Userforms.

You can find the Spreadsheet attached here for reference regarding the issue.

I have created a form "frmSelection" and it pops up when the "Check Section" command button is clicked. After displaying the form, I tried to keep option button "IS800-1984" default enabled.

If user changes the "Code Selection", for example "IS 800-2007" then another form will be displayed, i.e., frmIS8002007.

When this form is opened, I want to keep "Simply Supported", "Restrained" and "Hot Rolled Sections" enabled by default.

I even wrote the corresponding code but I am unable to get these controls enabled by default.

Kindly refer to the attached sheet and suggest me.

Thanks in advance
Srinivas

[mohd9876]

add the following code to the frmSelection form:

Private Sub UserForm_Activate()
Me.optIS8001984.Value = True
End Sub

and this code to frmIS8002007 form

Private Sub UserForm_Activate()
Me.optSS.Value = True
Me.optRestrained.Value = True
Me.optStandard.Value = True
End Sub

[nivassrii]

Do I need replace UserForm with my Form name.

[mohd9876]

no you don't just insert them as they are

[nivassrii]

Then, where do i need to insert them?. I am a bit confused where to insert this. Please misunderstand.

[mohd9876]

the first one in the frmSelection code module,, right click on the form and select view code then copy and paste the above code.
the second one in the frmIS8002007 code module,, do the same as above

[nivassrii]

Thank you,

It's done. I ve one more doubt. How can I interlink between two different forms. I mean to say getting data from one form through user entries and trasferring the same to other form in order to use them for rest of the calculations.

Also, is there a way to link between "Cancel" button in my form to the form Close button

[nivassrii]

After selecting few options in "frmSelection" and if once the Cancel button is pressed and opted "No" in order to come to the previous window, earlier selections have been erased. How to avoid this.

Can somebody suggest me.

[pike]

Hi nivassrii,
If your question is solved please change the prefix to “solved”. If you have another question start a new thread. This is to ensure the thread title and question is relevant, helping those searching for a similar requirement.

[nivassrii]

Hi nivassrii,
If your question is solved please change the prefix to “solved”. If you have another question start a new thread. This is to ensure the thread title and question is relevant, helping those searching for a similar requirement.

Thank you. Sure I do. But how can I set [Solved]

[pike]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save