Thanks for reply macropod.

i need assistance with the code on how to link between ActiveDocument.Bookmarks("BookmarkName").Range.Text and Excel UserForm Textbox.

Thanks in advance.