launch macro using text

[mani_singh]

hi i have a macro which i need to launch if i click on a populated entry in column c.

i already have the macro ready which currently runs if i highlight the cell (using a worksheet function), if it's populated it takes the data from that cell and runs the macro. i want this to occur if i select the cell.

thanks

 

[mani_singh]

i'm currently using selectionchange worksheet function, i've tried change worksheet function but its not what i need.

i need it to run if i click on it.

many thanks

 

[DonkeyOte]

Assuming you don't want to fire on a double click just a selection you would need to use the Worksheet_SelectionChange event for that sheet object and then call your other macro parsing say Target.Value to it... if your other macro is not desinged to have the cell reference parsed to it you would need to adjust it:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 3 And Len(Target.Value) > 0 Then
    Call OtherMacro(Target.Value)
End If
End Sub

to insert the above right click on the sheet to be used and choose view code and insert.

to adjust other code to accept parsed value:

Sub OtherMacro(tv As Variant)

End Sub

You may want to change tv to reflect actual data type being parsed (ie Range, Integer, Double, Long, Str) etc...

 

[mani_singh]

i'm using this idea currently but i dont want it to run when i highlight the selction, you mentioned double clicking would work. what is the command for this function

 

[DonkeyOte]

If you're au fait with the Worksheet events then go to where you have your selection change event, in the right hand drop down list you will see the events you can "capture" -- one of which is <b>beforedoubleclick</b>

You will want to ensure that again the Target.Row/Column and Value etc meet your crieteria prior to firing subsequent code.

 

[mani_singh]

Cheers