How to refrence another cell from within a text string

Ok, I need to use a text string in one cell, say cell B2 in another cell, say B3.

Say B2 contains the letters ball .

B3 contains the following:
=QLink|Bars!'textstring,1,1000,C'

I want textstring to be ball , but right now I have to hand change the textstring every time. How can I make it reference B2 instead?

Also, how do I make a VB macro to type ctrl + shift + enter after changing the string in cell B3?

Your help is greatly appreciated.