Select Contents of Cell With Macro

[MikeG]

I would appreciate if someone could tell me what VBA code to use to highlight the contents of a cell when it is seleted.

So for example, if Cell C4 has the word "Product" in it, then when the user selects that cell, the whole word would be highlighted.

Thanks,

MikeG

 

[Weaver]

Depends what you mean by highlighted. Yellow background? Bold text?

Should the highlighting be removed when the cell is no longer selected?

Could it apply to a whole selected range or just the active cell?

 

[MikeG]

Depends what you mean by highlighted. Yellow background? Bold text?

Should the highlighting be removed when the cell is no longer selected?

Could it apply to a whole selected range or just the active cell?

Thanks Weaver. I don't mean the format - I mean the text is selected in the same way you can user the cursor to select characters - whether in Excel, Word, webpages etc.

MikeG

 

[Weaver]

Ah, I see what you mean.

I'm not sure that you can. What are you looking to do once they're selected?

 

[MikeG]

Ah, I see what you mean.

I'm not sure that you can. What are you looking to do once they're selected?

Actually, it gets more complicated (!). From MrExcel, I have a macro that creates a "word-complete" for a cell that incorporates a pull-down list. This works well, except that often the user wants to start fresh and not edit the previous entry that was in the cell. So if I can highlight that entry, then they can simply type the first letter of their new word and the existing one will be deleted - if you see what i mean.

This is the behavior for the top-right entry box in Windows Explorer, for example, and I think what most users expet for auto-completion.

Thanks,

MikeG

 

[Weaver]

This also seems to be the behaviour of a normal cell in excel - you select a cell with text and if you start typing, the newly typed text replaces what's already there.

I suspect there's something in the 'autocomplete' text that's preventing this from happening - could you post the code or preferably a link to where I can find it?