Combo Box in Excel

[Guest]

Is there any sample code or Artilcle on how to create combo box in Excel at run time?

Thx in advance
Rami

 

[Kalle]

Use controls.add for this.

But it is much more easier to place the Comobox at design time and set the
Propperty Visible to false.

So You can easily control the postition and other stuff.

With the first method You have to specify all settings with your code.

greetings Kalle

 

[Tom Ogilvy]

Where do you want to put it. Userform? Worksheet?

What type of combobox - forms toolbar, control toolbox toolbar, Data
validation with the list option.

 

[Guest]

Hi
I want to Keep Combo Boxes at run time on Work sheet. Run time only decides on which cell the combo box goes.Is there any way to achieve this using C# and Form

----- Tom Ogilvy wrote: ----

Where do you want to put it. Userform? Worksheet

What type of combobox - forms toolbar, control toolbox toolbar, Dat
validation with the list option

 

[Tom Ogilvy]

I am sure there is, but I don't C#, and if you mean windows forms, I don't
see where they play. You probably need to do Ole automation (COM) of the
Excel/Office controls rather than try to introduce something from outside
Excel.



--
Regards,
Tom Ogilvy

Hi,
I want to Keep Combo Boxes at run time on Work sheet. Run time only

decides on which cell the combo box goes.Is there any way to achieve this
using C# and Forms