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.
Bookmarks