View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rich J Rich J is offline
external usenet poster
 
Posts: 16
Default cell overflow problems

If the sentences don't have to change then go to
Inser
Commen
delete anything that Excel automatically puts in the text box that appears and retyp
the sentence that is in the cell. Reshape the text box to be long and short
The user would then see the sentence that is in the cell
If the sentences change then VBA can add the comment later to the cell.