Pull specific data into word from excel based on user input

[dontquit]

Hi,

I want to run a macro in word wherein, I want word to display a dialog box, which will accept my input.

Based on that input, I want to vlookup in an excel file and get the relevant data into word.

Not sure how to do this.

Appreciate if anybody could help?

 

[BrianB]

Here is some similar code. You can change it to use Inputbox.

http://www.mrexcel.com/forum/showthread.php?t=348180

 

[dontquit]

Hi Brian,

Thanks for the reply, I had used that same code, but I am getting an runtime error on the "Redim" statement.

Many thanks for your help, can u pls tell me why it's happening

Rgds