ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   change event procedure (https://www.excelbanter.com/excel-programming/344713-change-event-procedure.html)

natanz[_2_]

change event procedure
 
i have the following code in my change event procedu

Private Sub ComboBox10_Change()
Dim ftype As Integer
Recalc
ftype = 2 + ComboBox10.ListIndex
Call PriceToCell(12, ComboBox10, 20, ftype)
End Sub

I would like to generalize it, so that i can copy it to some other
locations. Is there some name i can use to replace the text
ComboBox10. I tried to use "Me", but that didn't work.



All times are GMT +1. The time now is 11:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com