ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   assign the sub to the object event (https://www.excelbanter.com/excel-programming/309792-assign-sub-object-event.html)

Marek

assign the sub to the object event
 
people,

1. i create dynamically worksheet with X comboboxes
2. i want that each my combobox when occurs change event executes a m
sub


for exapmle

oleobjects("dynamically created combobox").change = MY SUB


it is possile i think ...

where i can read about events and handlers, people i try to find an
help, in the v help


thanks

maybe you can tell me any links about events

--
Message posted from http://www.ExcelForum.com


No Name

assign the sub to the object event
 
hi,
try this site
http://www.cpearson.com/excel/events.htm

-----Original Message-----
people,

1. i create dynamically worksheet with X comboboxes
2. i want that each my combobox when occurs change event

executes a my
sub


for exapmle

oleobjects("dynamically created combobox").change = MY SUB


it is possile i think ...

where i can read about events and handlers, people i try

to find any
help, in the v help


thanks

maybe you can tell me any links about events ?


---
Message posted from http://www.ExcelForum.com/

.



All times are GMT +1. The time now is 12:31 PM.

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