SETTING FOCUS TO A CELL IF SINGLE CLICKED

J

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
 
J

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.
 
J

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
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top