Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Issues with Combo Box change event
Hi,
I have a worksheet in which depending upon user selection one of the available templates(other worksheets in the workbook)is copied to a new sheet named as Input. I have a combo box on the templates. And I have an event associated with the comboBox (AxialDyn_CMB). Private Sub AxialDyn_CMB_Change() Call AxialDynSelection End Sub Now when I copy the template this code also get copied to the Input sheet. When I change the selection in combo box on input worksheet excel runs both the instances of above code i.e. it runs the"Private Sub AxialDyn_CMB_Change()" for both the template and the Input worksheet. I always thought that private subs are only associated for the sheet they are written for. But this issue defies it. Can anyone please help me with this. Regards Akansha *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo box change event fires twice | Excel Programming | |||
Worksheet change event with cell linked to combo box result | Excel Programming | |||
combo box change event | Excel Programming | |||
No change event on control toolbox combo box when selection is the same? | Excel Programming | |||
Help with a Combo Box Change Event | Excel Programming |