malik641
11-01-2007, 06:12 PM
Hey Guys,
I'm trying to make a little piece of code that acts like a "Text Edit" control. The idea is to click on a cell one time only and it would act like you double-clicked the cell (or pressed F2). The problem is I really don't like the approach I thought of, but I'm not sure what else I could use.
By the way, I will have a control boolean value to determine if the following Workbook event code will execute:
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
SendKeys "{F2}", True
End Sub
Any ideas?
I'm trying to make a little piece of code that acts like a "Text Edit" control. The idea is to click on a cell one time only and it would act like you double-clicked the cell (or pressed F2). The problem is I really don't like the approach I thought of, but I'm not sure what else I could use.
By the way, I will have a control boolean value to determine if the following Workbook event code will execute:
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
SendKeys "{F2}", True
End Sub
Any ideas?