Help with Arrays & Cascading Data

[JenkinsM82]

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:

• A combobox called "StatementName"
• 2 option buttons called "Singular" & "Plural"
• A textbox called "Statement"

The data comes from Statements.xlsx has 1 sheet with 3 columns. Column A is the Statement Name. Column B is the statement in singular form. Column C is the statement in plural form.

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!