NumberCrunch
03-15-2013, 02:55 AM
Hi,
I am having a process that starts when I'm double clicking a cell. It used to work perfectly when the process was in a standard module in a sub that was called from a worksheet module:
worksheet:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Call AddInfo(Target)
End Sub
Module:
Sub AddInfo(Target As Range)
[process]
End Sub
However, now I want the process to be in a form code. But I need to carry the target range properties, so I know the target cell.
There is 1 solution that I have, but it seems for me just too "unprofessional", if You know what I mean. It would be to put the range properties (row number and column number) in a specific place in the workbook, that I would read again once the form is launched and then clear the cells.
I'm trying to keep the code clean and elegant :). Any ideas how to transfer range variable to form?
I am having a process that starts when I'm double clicking a cell. It used to work perfectly when the process was in a standard module in a sub that was called from a worksheet module:
worksheet:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Call AddInfo(Target)
End Sub
Module:
Sub AddInfo(Target As Range)
[process]
End Sub
However, now I want the process to be in a form code. But I need to carry the target range properties, so I know the target cell.
There is 1 solution that I have, but it seems for me just too "unprofessional", if You know what I mean. It would be to put the range properties (row number and column number) in a specific place in the workbook, that I would read again once the form is launched and then clear the cells.
I'm trying to keep the code clean and elegant :). Any ideas how to transfer range variable to form?