|
-
May 4th, 2006, 12:41 PM
#1
Thread Starter
Fanatic Member
vba access - refer to the control that was clicked
I've got a form with 72 text boxes, sorted in a 6*12 matrix. the text box names are Cell_[row number]_[Column number].
I'd like that double clicking all the 72 text boxes will call the same function with the paramaters of the Cell's row number and column number.
for example: the sub for cell_0_1 looks like:
Private Sub Cell_0_1_DblClick(Cancel As Integer)
Call OpenCell (me.cell_0_1)
End Sub
is there a way to work this out without writing 72 ugly sub routines?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|