You might try to use the Event code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)

this goes in worksheet code and allows you to execute a macro when you
double-click. I just don't know what your code would do.
--
Gary''s Student - gsnu200716


"ToddG" wrote:

I guess that doesn't work for me either.

What I have is code residing in the Worksheet that inserts a cell comment
then displays an InputBox for entering the comment text when a cell is double
clicked. What i'd like this to do is the exact same thing when I double click
a ComboBox and have it insert the comment to the ComboBox's ControlSource
cell.


"IanKR" wrote:

You can sort of do it functionally. Double-clicking a cell
(manually) puts you in Edit mode.

That only works for me if I have "Tools | Options | Edit | Edit directly in
cell" checked (which I don't usually have) and even then, the insertion
point appears in the cell's current contents relative to where you click in
the cell. To make it appear at the (right) end of the cell's current
contents you first have to make sure the cell's column is wide enough, and
then click far enough over to the right of the cell.