select contents of cell

[dlh]

This ought to be very easy, but browsing the help files doesn't help:

I'm writing my own data validation routine. If the validation fails, I want the contents of the failed cell to be selected (so the user can begin typing new content for the cell without touching the mouse). All I know how to do is:

MyCell.Select

which selects the cell, but not its contents.

-dlh

[Tom Ogilvy]

Sub ValidationFailed(mycell As Range)
mycell.Select
SendKeys "{F2}{Home}+{End}"
End Sub

Sub TestCode()
Dim mycell As Range
Set mycell = Range("F3")
ValidationFailed mycell
End Sub

--
Regards,
Tom Ogilvy

"dlh" <[email protected]> wrote in message
news:[email protected]...
>
> This ought to be very easy, but browsing the help files doesn't help:
>
> I'm writing my own data validation routine. If the validation fails, I
> want the contents of the failed cell to be selected (so the user can
> begin typing new content for the cell without touching the mouse). All
> I know how to do is:
>
> MyCell.Select
>
> which selects the cell, but not its contents.
>
> -dlh
>
>
> --
> dlh
> ------------------------------------------------------------------------
> dlh's Profile:
http://www.excelforum.com/member.php...o&userid=26113
> View this thread: http://www.excelforum.com/showthread...hreadid=399940
>

[dlh]

SendKeys ... the concept I was missing. Thank you very much!