Common vba code for multiple Buttons 1

[jpl458]

Have a from that ras for text boxes and 40 lables. I want to create a double click event for each of the 40 lables, that will update a table with 40 rows. Is there a way to have one piece fo code that can be used by each of the 40 double click events, (which is a snap in 360/370 assembler "BAL R5,mylable"), or do I have to copy and change each of the forty when I creat then and change all 40 if a change is required? I would need to pass something identifying the lable. Would a function do the trick, I am just thinking.

jpl458

 

[PHV]

You may write a generic function dealing with the Screen.ActiveControl.Caption property

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jpl458]

Yes. Thanks again

jpl