sankartalam
08-17-2008, 04:02 AM
Folks,
could anyone give me the solution for my following requirement!
I have 5 modules in my vb code and each module has 2 or 3 sub programs in personal.xls and one private sub program (which is Worksheet_SelectionChange()) in the active work sheet. I have to call one of the sub program which there in any of the module when the selection changes.
For better understanding the senerio I am sending you the modules&sub programs hierarchy pictures.
Sheet2 is the active work book sheet.
I want to call one of the sub program in the toolbar module whenever the selection changes.
could anyone give me the solution for my following requirement!
I have 5 modules in my vb code and each module has 2 or 3 sub programs in personal.xls and one private sub program (which is Worksheet_SelectionChange()) in the active work sheet. I have to call one of the sub program which there in any of the module when the selection changes.
For better understanding the senerio I am sending you the modules&sub programs hierarchy pictures.
Sheet2 is the active work book sheet.
I want to call one of the sub program in the toolbar module whenever the selection changes.