Thread: Combo Boxes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JT JT is offline
external usenet poster
 
Posts: 234
Default Combo Boxes

I have a user form that has 2 combo boxes. 1 is for debits and the other is
for credits. Each form is multi-select.

I am adding 2 labels; one at the top of each combox. I would like to
display the total of all selected in each combobox. If the user selects
another item, the amount displayed increases. Likewise, it the user
de-selects an item, the amount displayed decreases.

There are 6 fields in each combobox. The amount is the 3rd field in the
debit side and the the 4th field in the credit side.

I'm having a little difficulty getting started. How can I tell when an item
as been selected and when it has been de-selected.

Any help would be greatly appreciated. Thanks for the help.......

--
JT