I want to know if this is possible? If I have text in column A can I
scroll down the text and in let's say in cell B1 it shows the text of
where my cursor is? So if my cursor is on cell A5 B1 shows the text in
A5 if I scroll down and stop on A15 cell B1 shows the text in A15.
Tried searching but couldn't find anything.
TIA

Very difficult if you mean a mouse hover (like viewing a comment). Easy if
you mean clicking on a cell or using the arrow keys to navigate up & down.

Put the following event macro in the worksheet code area:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Set r = Range("A:A")
If Intersect(r, Target) Is Nothing Then Exit Sub
Application.EnableEvents = False
Range("B1").Value = Target.Value
Application.EnableEvents = True
End Sub

--
Gary''s Student - gsnu2007d


"(E-Mail Removed)" wrote:

> I want to know if this is possible? If I have text in column A can I
> scroll down the text and in let's say in cell B1 it shows the text of
> where my cursor is? So if my cursor is on cell A5 B1 shows the text in
> A5 if I scroll down and stop on A15 cell B1 shows the text in A15.
> Tried searching but couldn't find anything.
> TIA
>

You could put some VBA code in your worksheet. Press Alt+F11 to activate
VBA. Select the worksheet name in the workbook where you want the code and
double click on it and paste the following code in the code window.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Target, Range("a:a")) Is Nothing Then Exit Sub
Range("b1") = Target
End Sub

Then press Alt+F11 to return to your worksheet.

If your cursor is in Column A you will see the value of the cell in Column A
appear in B1

<(E-Mail Removed)> wrote in message
news:04ea6fd7-b537-4645-a446-(E-Mail Removed)...
>I want to know if this is possible? If I have text in column A can I
> scroll down the text and in let's say in cell B1 it shows the text of
> where my cursor is? So if my cursor is on cell A5 B1 shows the text in
> A5 if I scroll down and stop on A15 cell B1 shows the text in A15.
> Tried searching but couldn't find anything.
> TIA

On Feb 7, 6:47 pm, "Tyro" <T...@hotmail.com> wrote:
> You could put some VBA code in your worksheet. Press Alt+F11 to activate
> VBA. Select the worksheet name in the workbook where you want the code and
> double click on it and paste the following code in the code window.
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> If Intersect(Target, Range("a:a")) Is Nothing Then Exit Sub
> Range("b1") = Target
> End Sub
>
> Then press Alt+F11 to return to your worksheet.
>
> If your cursor is in Column A you will see the value of the cell in Column A
> appear in B1
>
> <erable...@gmail.com> wrote in message
>
> news:04ea6fd7-b537-4645-a446-(E-Mail Removed)...
>
> >I want to know if this is possible? If I have text in column A can I
> > scroll down the text and in let's say in cell B1 it shows the text of
> > where my cursor is? So if my cursor is on cell A5 B1 shows the text in
> > A5 if I scroll down and stop on A15 cell B1 shows the text in A15.
> > Tried searching but couldn't find anything.
> > TIA

beautiful exactly what I needed
Thanks