SETTING FOCUS TO A CELL IF SINGLE CLICKED

[James]

hi all, probably a quick question but i cant figure it out.....

how do you set the focus to a cell if it is single clicked?

here is my situation. I need to be able to single click on a cell and make
it set the focus as if it were double clicked. the criteria is that the
selection.interior.colorindex = 2 and this color is only in one part of my
spreadsheet. any help would be great, thanks

 

[JLGWhiz]

Hi James, your post is a little confusing since a single click on a cell does
set focus to that cell. I don't understand the connection to the
selection.Interiou.ColorIndex = 2, unless you are somehow trying to use a
worksheet change event to change the cell color when clicked.. Maybe you
could explain what you are tryiung to accomplish and we can give some
meaningful suggestions.

 

[James]

ok, when you double click a cell, the cursor blinks and you can type stuff in
this is what i meant by "set focus". I need it to do this when you SINGLE
click a certain column (ie. column that has colorindex of 2). the reason is
because i have merged cells and when copying text into it without double
clicking it wont let you. I just want to get rid of this paste error

 

[JLGWhiz]

I believe that goes beyond the scope of VBA. That gets into the application
design properties. Beyond my expertise if Excel does not provide a user
interface to change the cell activate event.