This will allow you to select any line of text, and then edit it using a dialogue box. If Else MsgBox Err. If End Sub Now insert a userform with a text box and two buttons. TextBox1.Text 'get the text string from the text box objPicked. Please respect the intellectual rights of others.
All material provided here is unsupported and without warranty of any kind.
No responsibility will be taken for any direct or indirect consequences resulting from or associated with the use of these Tutorials or Code. All rights reserved. Information in this document is subject to change without notice. Site created and maintained by Kenny Ramage.