I may not be following you completely but if you want to trigger event
handler code just call it.

--
Jim
"JimRWR" wrote in message
...
| Hi.
|
| I'm creating a product order form in VBA 6.3 for Excel 2000 that contains
a
| combobox for product id and textboxes for unit price, quantity and total.
| The form is designed so that the customer can add lines for additional
| products. In so doing, I need to be able to:
| 1. raise the change event of the product id combobox, so that the
| corresponding price appears in the unit price textbox
| 2. raise the change event of the quantity textbox so that the total
| calculates (quantity*price)
|
| As instances of these objects are created on the fly by the customer, I
| think I have to create class modules to raise and trigger change events.
| However, class modules are brand new to me so any help would be greatly
| appreciated.
|
| TIA,
|
| JimRWR