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