Add code to Private Sub ComboBox1_Change() with a macro from a different workbook

[help_wanted]

Is there a way to write code to Private Sub ComboBox1_Change() on one
workbook from a macro in another.

 

[Tom Ogilvy]

See Chip Pearson's site on this

http://www.cpearson.com/excel/vbe.htm

You should be able to use such code from another workbook.

 

[help_wanted]

Tom,
Thanks for the response but this link only shows how to add code t
or create a new module. I need to add code only to a sheet in th
separate woorkbook. Specifically to add if /then statements to

Private Sub ComboBox1_Change()

in a sheet in the separate workbook

Thanks again

 

[Tom Ogilvy]

"Creating An Event Procedure"

tells how to do what you want. The example is for the thisworkbook module,
but just changing thisworkbook to sheet1 for example, should get the job
done. Adjust to refer to the other workbook as well.

 

[help_wanted]

Still not sure exactly what im supposed to do here. Does anyone hav
some sample code for how this can be accomplished