Get DropDown Lists in 2007 out of AddIns

[Ed]

(Is there a new 2007 board that I should be writing to with this question?)

I have written a large program for 2003 (and before). I can create dropdown
lists for various selections I need to make, and position them in the
toolbar without problem. This is the essential code:

Set newlist = mybar.Controls.Add(Type:=msoControlDropdown)


For n = 1 To ubound(filenamed)

newlist.AddItem filenamed(n)

Next

newlist.OnAction = "DoStuff"



THE PROBLEM:

In 2007, the commandbar (list) appears in the AddIns tab. I have created a
new tab (called "My Program") that houses other commands regarding the
program (so I can at least move those command buttons out of the generic
"AddIns" tab). But I cannot figure out how to place the dropdown list into
the "My Program" tab. Any ideas?



Ed (in VA)

 

[Jean-Guy Marcil]

(Is there a new 2007 board that I should be writing to with this question?)

I have written a large program for 2003 (and before). I can create dropdown
lists for various selections I need to make, and position them in the
toolbar without problem. This is the essential code:

Set newlist = mybar.Controls.Add(Type:=msoControlDropdown)


For n = 1 To ubound(filenamed)

newlist.AddItem filenamed(n)

Next

newlist.OnAction = "DoStuff"



THE PROBLEM:

In 2007, the commandbar (list) appears in the AddIns tab. I have created a
new tab (called "My Program") that houses other commands regarding the
program (so I can at least move those command buttons out of the generic
"AddIns" tab). But I cannot figure out how to place the dropdown list into
the "My Program" tab. Any ideas?

For a discussion on what can/how it can be done, see
http://pschmid.net/blog/category/office-2007/office-2007-developer/
and
http://pschmid.net/blog/2006/10/18/68