View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RJR[_2_] RJR[_2_] is offline
external usenet poster
 
Posts: 3
Default Code to find and replace words inside of a text box

I have Office XP with Windows XP Pro.
Is there a tool available or a work around which will allow me to edit -
find/replace words inside of a text box. I have a text box that requires
edit - find/replace each time the spreadsheet is run. I need this to be
done via VBA and would appreciate anyone providing information how to do, or
if it can be done.
------------------------------------
Related Subject: Edit - Find/replace, manual or VBA, does not work if the
cell being edited contains more than 255 characters. Is there a workaround
this? (via VBA)

I numerous cells that will contain more than 255 characters that require
Edit- Find/Replace.

Thanks in advance
BOB REYNOLDS