PDA

View Full Version : Sleeper: Text Edit Mode



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?

JKwan
11-02-2007, 08:11 AM
Not too sure if this is what you mean, but does not hurt to look at it

http://www.cpearson.com/excel/FormulaBarShortcut.htm

I execute the code on SELECTION change