Displaying Excel Sheet data on VBA userform

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.

Hi,

Please find attached, the same table in excel format. Hope this helps.

Thanks,

I have still not been able to solve this one. Any ideas on this? Please help. Thanks!!

can I do same for combo box VBA