Import data in userform according to random Textbox value

Hi All,

I hope to be as clear as possible, as this is my first thread.
I'll immediately get to the point.
I have an Userform with a Button and 3 TextBoxes.
In the Sheet1 I have a list of values divided in 3 coloumns. In the first coloumn I have only numbers, from 1 to X. Both second and third coloumn show data which should be related to the value of the first cell in the same row.

When I press the button in the Userform, the Textbox1 show a random result among the numbers in the first coloumns. (I've no problem with this one)
At the same time, Textbox 2 and 3 must be populated showing the related data in the same row of coloumn 1 imported value. (I'm stucked here)
Hope it's clear..

Thanks in advance for your attention
R.

Please Login or Register  to view this content.

Thanks!! works perfectly!

Just a question,
how would the entire code change if I have to import this in openoffice?
(sorry if this isn't the right place for this question..)

thanks in advance
R.

'Open Office' recognises most VBA code.
I would something that simple would not cause a problem.