I am working on a project whose requirement steps are as follows:

• use a toolbar shortcut or a button to allow the user to browse for text files
• once, the user selects a file, import the data and display it in excel
• the data is a list of fields followed by a list of corresponding values
• the excel spreadsheet should look like a form/table with the field values on the left and its value of the right
• there could be color codes like green or red to represent certain type of fields' values
• the values imported from text files would then be populated into such "form/table"

I did create a basic vba program to browse text files. My main concern is regarding how to create visual elements like labels that represent the fields and text fields like elements into which the corresponding values would be inserted by the program (or some script). I have looked into several web resources but cannot find anything related to creating visual elements.

thanks.