Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Populate sheet name of active workbook in Combobox in Command
hi all,
i have an addin which has a Combobox in a commandbar and in the Auto_Open event of commandbar impopulating sheet names of active workbook but im not able to populate the same when i open another excel file. may be because the addin is already open in Excel... pls help how to achieve this for any excel file.. am im missing writing code in a particular event??? -- thanx.. Bhavtosh |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Populate sheet name of active workbook in Combobox in Command
In you addin you need to instantiate application level events. Then you
can trap the opening of a workbook See Chip Pearson's site for an introduction: http://www.cpearson.com/excel/AppEvent.htm -- Regards, Tom Ogilvy "Bhavtosh" wrote in message ... hi all, i have an addin which has a Combobox in a commandbar and in the Auto_Open event of commandbar impopulating sheet names of active workbook but im not able to populate the same when i open another excel file. may be because the addin is already open in Excel... pls help how to achieve this for any excel file.. am im missing writing code in a particular event??? -- thanx.. Bhavtosh |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Populate sheet name of active workbook in Combobox in Com
thanx for a gr8 link; it did help in knowing more abt events. one more favor
if u can do. right now user can type in the combo box how can i prevent it or how can i make it just a normal drop down? thanx bhavtosh "Tom Ogilvy" wrote: In you addin you need to instantiate application level events. Then you can trap the opening of a workbook See Chip Pearson's site for an introduction: http://www.cpearson.com/excel/AppEvent.htm -- Regards, Tom Ogilvy "Bhavtosh" wrote in message ... hi all, i have an addin which has a Combobox in a commandbar and in the Auto_Open event of commandbar impopulating sheet names of active workbook but im not able to populate the same when i open another excel file. may be because the addin is already open in Excel... pls help how to achieve this for any excel file.. am im missing writing code in a particular event??? -- thanx.. Bhavtosh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto populate unused rows from workbook to workbook | Excel Worksheet Functions | |||
how to populate active sheet | Excel Discussion (Misc queries) | |||
populate combobox with sheet names | Excel Programming | |||
populate combobox with sheet names | Excel Programming | |||
Adding Items To Active X ComboBox on Sheet | Excel Programming |