Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
auto populate unused rows from workbook to workbook JG Excel Worksheet Functions 1 March 16th 10 09:06 PM
how to populate active sheet veronica Excel Discussion (Misc queries) 1 March 13th 06 10:05 PM
populate combobox with sheet names David Goodall Excel Programming 3 September 12th 04 12:37 PM
populate combobox with sheet names David Goodall Excel Programming 0 September 12th 04 08:55 AM
Adding Items To Active X ComboBox on Sheet Dan Gesshel Excel Programming 3 October 20th 03 01:02 PM


All times are GMT +1. The time now is 11:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"