Double clicking a Cell Programatically
You can sort of do it functionally. Double-clicking a cell (manually) puts
you in Edit mode. Any characters entered after this will be appended tto the
existing cell contents. It also Selects the cell you double-clicked on.
Lets say we want to do this to cell A1:
Sub pseudo_double_click()
Range("A1").Select
Application.SendKeys "{F2}"
DoEvents
End Sub
This will leave you exactly as if you had double-clicked A1
--
Gary''s Student - gsnu200716
"ToddG" wrote:
Is it possible to double click a cell "programatically"?
I would like to double click a ComboBox and have it "double click" the cell
that is set as the ComboBox's ControlSource which will then run a macro
residing in the worksheet.
Is this possible? Any help would be greatly appreciated.
|