I have created a userform in MS word, and it consists of:
Style text field, Search button
Size combo box
Paste into Word button
When user type in a style, and click Search, the search will need to open up an excel file and search for the style in A1-A100. There might be 2/3 same style code, so it will need to list out the size of all the styles in the Size combo box
Lastly, when I click Paste into Word, it will paste the informations of the price, style code and size back into the MS Word table.
I'm new to VBA, so if anybody can guide me, I would appreciate it!!
Style text field, Search button
Size combo box
Paste into Word button
When user type in a style, and click Search, the search will need to open up an excel file and search for the style in A1-A100. There might be 2/3 same style code, so it will need to list out the size of all the styles in the Size combo box
Lastly, when I click Paste into Word, it will paste the informations of the price, style code and size back into the MS Word table.
I'm new to VBA, so if anybody can guide me, I would appreciate it!!
