D
Docwho
A neophyte with VB programming looking for help in regards to opening forms
in different Office applications. One form is in Word and the other is in
Excel. The Word document is an information form with some controls. From the
Word document, a user can launch the Excel Form. Both forms are protected.
Using: Word 2000 and Excel 2000.
The Excel form contains several option buttons, checkboxes and textboxes.
When these controls are changed VBA sub procedures run and set values for
other fields.
My problem:
When checking any of checkboxes, option buttons or input data to text
fields, the resulting vb code runs (change event), but the form data is not
updated until I click the form fields (those changed by the sub procedures).
This only happens when I launch the Excel form from Word and not on its own.
Am I missing object references, a quirk with Office 2003, environment set up??
Many Thanks.
in different Office applications. One form is in Word and the other is in
Excel. The Word document is an information form with some controls. From the
Word document, a user can launch the Excel Form. Both forms are protected.
Using: Word 2000 and Excel 2000.
The Excel form contains several option buttons, checkboxes and textboxes.
When these controls are changed VBA sub procedures run and set values for
other fields.
My problem:
When checking any of checkboxes, option buttons or input data to text
fields, the resulting vb code runs (change event), but the form data is not
updated until I click the form fields (those changed by the sub procedures).
This only happens when I launch the Excel form from Word and not on its own.
Am I missing object references, a quirk with Office 2003, environment set up??
Many Thanks.