Hi,

I'm trying to use the RefEdit control on a userform to select a range on a
worksheet to paste the contents of a text box to. on pressing the refedit
button it navigates to a different sheet in the same workbook (which is what
i want), producing a value of

'Lab Request'!$C$8

which is fine, thats where i want to data to go, but i can't work out how to
tell vb to put the contents of textbox2 to that cell reference... i can
normally work this sort of thing out, but not this time - something tells me
its really easy.

tia,
tim