Generic name for buttons.

[paulbradley]

I have A LOT of command buttons on one form. I want to write a function that changes the colour of the text box next to the button when it is pressed. I don't mind pasting a function call in for the 'on click' event for each button, but how do I write the function so it knows which text box to alter the colour of? Thanks!

 

[mck144]

pass the text box name as a parameter into the function

Function Change_Color(textbox)
.
.
.
End Function

So when you call it in the On Click event

Sub Command_Click
Call Change_Color(textboxname)

End Sub

 

[Eupher]

Yup, that's a good way to do it. Another way is to refer to Screen.ActiveControl

Ken S.