Vba code to automatic select a frame button when i click on a textbox

[erickfloyd]

I need Vba code to automatic select a frame button when i click on a textbox

[pbaldy]

Set focus to it or set the value of it?

Me.FrameName = x

to set the value.

[erickfloyd]

Thank you!! Done! That's works but now i'm trying to keep two actions together but i can't.


Private Sub Text11_Click()
Me.Frame19 = "3"
End Sub

Private Sub Text11_Click()
Text11.Value = ""
End Sub

[pbaldy]

More like:

Private Sub Text11_Click()
  Me.Frame19 = "3"
  Text11.Value = ""
End Sub

[pbaldy]

Oh, and I'd expect the frame to have a numeric value (no quotes around the 3).

[erickfloyd]

pbaldy thanks a lot, you cleared my doubts!!!

[pbaldy]

Happy to help!