See results of VLookup formula

Hi
The contents of the cells I'm returning using VLookup are quite hefty and
I'd like the users to see the contents in the input line, not the formula
when they click on the cell. The only way they can see the contents is to
make the cell height bigger which is really not convenient for what we're
doing. Does anyone know a way to do this?

Marie

This will put the results in a Comment Box.........

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
' This macro, placed in a WorkSheet module will automatically
' copy a cell's value over to it's comment box, so large text
' fields in a cell can be viewed without resizing the worksheet.
On Error Resume Next
ActiveCell.Comment.Text Text:=ActiveCell.Value
End Sub

hth
Vaya con Dios,
Chuck, CABGx3



"MarieB" wrote:

> Hi
> The contents of the cells I'm returning using VLookup are quite hefty and
> I'd like the users to see the contents in the input line, not the formula
> when they click on the cell. The only way they can see the contents is to
> make the cell height bigger which is really not convenient for what we're
> doing. Does anyone know a way to do this?
>
> Marie

Great bit of code, that worked a treat. Thanks
--
Marie


"CLR" wrote:

> This will put the results in a Comment Box.........
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
> ' This macro, placed in a WorkSheet module will automatically
> ' copy a cell's value over to it's comment box, so large text
> ' fields in a cell can be viewed without resizing the worksheet.
> On Error Resume Next
> ActiveCell.Comment.Text Text:=ActiveCell.Value
> End Sub
>
> hth
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
> "MarieB" wrote:
>
> > Hi
> > The contents of the cells I'm returning using VLookup are quite hefty and
> > I'd like the users to see the contents in the input line, not the formula
> > when they click on the cell. The only way they can see the contents is to
> > make the cell height bigger which is really not convenient for what we're
> > doing. Does anyone know a way to do this?
> >
> > Marie