Displaying Excel Sheet data on VBA userform

[sprasadv]

Hi,

I have a table in an excel sheet as shown in the file attached with this post. I also have a user form with a command button and a text box.

As you can see, the table has 4 columns and multiple rows. Based on the value in column 1(titled as "ID#"), I want to select the text displayed in columns 2,3 and 4 and display it as a table on the user form keeping all the formatting(color coding, column width and height etc) intact. I want this to happen when the user clicks the command button.

Can someone please suggest me how to go about doing this? Would a text box work or would I have to use some other form of control? Please advise.

Thanks a lot.