This message https://www.mrexcel.com/forum/excel-questions/726568-frame-control-activex-option-button.html Showed me how to add the buttons to a frame, which I did easily, What I don't know is how to access the controls on the frame when they are clicked. I experimented and can address them like this Private Sub frm_SearchBy_Click() Me.frm_SearchBy.Controls("txt_Item").Text = "Hello" End Sub which will change the value in the textbox, but I also have option buttons and command buttons which I want to have trigger events when they are clicked on, which I cannot seem to be able to do. Any ideas?

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

referencing controls on an activex frame control.

Thread starter Richard U
Start date Mar 5, 2018
Tags

buttons clicked controls end frame

Richard U

Active Member

Mar 5, 2018

This message

https://www.mrexcel.com/forum/excel-questions/726568-frame-control-activex-option-button.html

Showed me how to add the buttons to a frame, which I did easily,

What I don't know is how to access the controls on the frame when they are clicked.

I experimented and can address them like this

<code>
Private Sub frm_SearchBy_Click()
Me.frm_SearchBy.Controls("txt_Item").Text = "Hello"
End Sub
</code>

which will change the value in the textbox, but I also have option buttons and command buttons which I want to have trigger events when they are clicked on, which I cannot seem to be able to do.

Any ideas?