JenkinsM82
New Member
- Joined
- May 17, 2018
- Messages
- 9
Hi Everyone! I'm looking for some help displaying some data from Excel into a Word UserForm using arrays but I'm having trouble wrapping my head around it.
The UserForm has the following controls:
When the form initializes, I want the data from Statement.xlsx to be loaded into an Array. When the combobox or optionboxes are changed, the textbox should update accordingly.
The last part is to allow the user to modify the textbox before clicking a submit button to insert the statement into the Word document.
Thanks in advance!
The UserForm has the following controls:
- A combobox called "StatementName"
- 2 option buttons called "Singular" & "Plural"
- A textbox called "Statement"
When the form initializes, I want the data from Statement.xlsx to be loaded into an Array. When the combobox or optionboxes are changed, the textbox should update accordingly.
The last part is to allow the user to modify the textbox before clicking a submit button to insert the statement into the Word document.
Thanks in advance!