Select text in cell

[gallen]

Hello,

I have a feeling this is very simple but having searched can't find any help on this.

Basically I want to set focus back to a specific cell (easy enough) and then select the content of the cell.

I can't work out how to put the cursor inside the cell and select all the text it contains.

Any suggestions?

Thank you

 

[littleiitin]

Hi,

Welcome to the board.

Please try the below code

Sub SelectCell()
   Range("A1").Select
   Range("A1").Copy
   Range("C1").PasteSpecial xlPasteAll
End Sub

 

[Rick Rothstein]

I think you will need to provide a little more information. You do not have to put the cursor inside the cell nor do you have to physically have to select any text in the cell in order to obtain the text. You can use the Value property or the Value2 property or maybe even the Text property directly... it kind of depends on what type of information is in the cells and what you want to do with it once you have it. Can you give us a little more detail about your setup and what you are hoping to do with it?

 

[gallen]

Yes sorry. I'll try to be clearer.

I am validating data using VBA instead of the built-in data validation.

If the data is invalid I need to set focus back to the cell and select the text so that if they move off the cell again the worksheet_change event is triggered

 

[Sektor]

[COLOR="Blue"]Sub[/COLOR] SelectText()
    Application.SendKeys "{F2}+{HOME}"
[COLOR="Blue"]End[/COLOR] [COLOR="Blue"]Sub[/COLOR]

 

[gallen]

Thank you all for your replies.

Sektor's code works just fine