value of a cell

[NewbiDoobie]

I am not sure if there is a way to do this in excel, but if a user double clicks on a cell in a specific column, can I have the value of that cell passed to a macro to autofill another group of cells based on that value?

 

[rmikesmith]

Yes you can. In the code module for the Worksheet of interest, include something like this procedure:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
   Cancel = True
   MySub Target.Value
End Sub

In a standard code module you would have your procedure (macro) that you want to pass the value to. Example:

Sub MySub(ByVal vIn As Variant)

   MsgBox "vIn = " & vIn
End Sub

HTH
Mike