Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add code to Private Sub ComboBox1_Change() with a macro from a different workbook
Is there a way to write code to Private Sub ComboBox1_Change() on one
workbook from a macro in another. --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add code to Private Sub ComboBox1_Change() with a macro from a different workbook
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. -- Regards, Tom Ogilvy "help_wanted " wrote in message ... Is there a way to write code to Private Sub ComboBox1_Change() on one workbook from a macro in another. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add code to Private Sub ComboBox1_Change() with a macro from a different workbook
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 -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add code to Private Sub ComboBox1_Change() with a macro from a different workbook
"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. -- Regards, Tom Ogilvy "help_wanted " wrote in message ... Tom, Thanks for the response but this link only shows how to add code to or create a new module. I need to add code only to a sheet in the separate woorkbook. Specifically to add if /then statements to Private Sub ComboBox1_Change() in a sheet in the separate workbook Thanks again. --- Message posted from http://www.ExcelForum.com/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add code to Private Sub ComboBox1_Change() with a macro from a different workbook
Still not sure exactly what im supposed to do here. Does anyone hav
some sample code for how this can be accomplished -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to code VBA: Auto open workbook and run macro | Excel Discussion (Misc queries) | |||
VBA Code to kick off macro when workbook command to close is initi | Excel Discussion (Misc queries) | |||
VBA Code To have a macro repeat on all sheets in a workbook | Excel Worksheet Functions | |||
Place code in a new workbook with a macro. | Excel Programming | |||
VBA code to delete VBA code in another Workbook | Excel Programming |