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?