allocating to display the searched item in testboxes dynamically

Hi,

I am new to VBA macros and trying to create display the searched items in the TEXT boxes for e.g


I have the data in one sheet as below.

Messgae Code Program Name Error Description
asds asds qwewe
w987 oiuhad 2343
789 ARU100 Praveen Code
789 ujiikl uiooqwe
asds asds asdsd
a98734 iuhasdn okhu434
9217432 kjhasdmna lkjsfdsaiuaf
98734345 kjhsafjahf jhsfd;lkhjsdf
sjdhjh kjhasdh lkalshdks
kjahsd kjhasdalkh lkhasdlkj
nmbfmn, nmsdfdf asdasd

i have created one text box so that user enter the data to search by giving Message code. My concern is

From the example,

If the user enter 789 in the text box, and click on te search button( On user form) then it should dynamically create displays 2 occurance in each text box.i.e if the 789 found in 1 col then it should create 4 test boxesto display Program name data and 4 text boxes to display Error Description side by side. if not text boxes if will be if we display in lables also.