Hi All,

I have created a user form in word and its loaded when document is active. I have text field where user enters a unique number. Upon button click I want the unique number to be verified by looping it in Excel sheet and upon successful find the values in all the cells for unique to be transferred to string variables or in array form back to word.
I have another mail merge macro which will then use these string values to populate the table along with other fields

Big thanks in advance...

Mohammed