I am creating a script/questionaire that will be used by different people. I
would like to create a form (Excel?) where I could enter a question in one
cell then wrap the text in the answer cell, allow the person who is writing
the answer to use as man lines as they want but freeze the height of the
answer cell (to 3 lines) - THEN put a 'button' on/near the answer cell that
would allow someone viewing the completed questionaire to choose wether they
want to view the entire answer.... phew. I've got everything done (thanks to
the forum) except for the 'putting the button on/near the cell to view the
entire contents' part. I know I can just select the cell and go to row -
auto fit but is there another way.
Thanks

One way would be to insert a Comment Box on each of the cells which will
become "answer cells", and then put this macro in the WorkSheet Module for
that sheet.........then, whenever text is entered thereafter into the cell,
it will be automatically copied over to the comment box which will pop-up
when moused over.....

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.
' by Chuck Roberts, CABGx3
On Error Resume Next
ActiveCell.Comment.Text Text:=ActiveCell.Value
End Sub

Vaya con Dios,
Chuck, CABGx3




"Graham Smith 450-458-0101" wrote:

I am creating a script/questionaire that will be used by different people. I
would like to create a form (Excel?) where I could enter a question in one
cell then wrap the text in the answer cell, allow the person who is writing
the answer to use as man lines as they want but freeze the height of the
answer cell (to 3 lines) - THEN put a 'button' on/near the answer cell that
would allow someone viewing the completed questionaire to choose wether they
want to view the entire answer.... phew. I've got everything done (thanks to
the forum) except for the 'putting the button on/near the cell to view the
entire contents' part. I know I can just select the cell and go to row -
auto fit but is there another way.
Thanks