Help need for UserForm VBA - MS Word 2010

[krjoshi]

Hi Folks,

Please find attched the two files (MS Word and MS Excel). Please note that the excel file is working perfect, the same functions I need in MS Word so that I can use the MS Word file like a master template. When i click on "Select Hazard" command button (in MS Word) the userform should be shown for Activity and Hazard selection, when i click the Copy Hazards button (in Userform) all ComboBox & ListBox selected items to paste into Page 2 approppriate columns (Activity, Hazard & Control Mesures) with the Step # (First Column in Word file page-2).

Please see attached files for more details.

Thanks in advacne.

Joshi

 

[SkipVought]

hi,

Welcome to Tek-Tips.

Many of us are restricted from downloading files by our companies.

If you want immediate help, please post ALL your information and descriptive examples directly here. This is how it is normally done at Tek-Tips.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[krjoshi]

Hi Skip,

Thanks for your reply. I have a Document (MS Word 2010) with an userform contains ComboBox1, ListBox1, CommandButton1 and CommandButton2 also I have an excel workbook named JsaData.xls and having records in Sheet1 Column A "Activities", Column B "Hazards" and Column C "ControlMeasure". I need to set ComboBox1 RowSource to JsaData.xls (Sheet1) Column A:A and the ListBox1 values should be changed based on ComboBox1 selection (e.g excel sheet1 Cell A2 Value = "Area Preparation", B2 Value = "Pinch points" and Cell C2 Value = "Inspect tools". If I select combobox1 "Area Preparation" the Listbox1 should display "Pinch points" then I click on CommandButton1 the selected items (Combobox1 and listbox1 selected items) to be pasted in appropiated tables in the Word Document (the Word doc Tables same as the excel file columns "Activities", "Hazards" and "ControlMeasure").

Can you please help me...

Joshi