This appears to be one of the common controls - don't these require a
license for design time operation - the mode Office operates in?

--
Regards,
Tom Ogilvy

"keepitcool" wrote in message
...
in the VBEditor

Rightclick the Control Toolbox
Select additional controls..
try to find Microsoft Toolbar control

add it to the toolbox then drag into form.
now open properties window..
select the custom property to open the properties bag.

check object browser for more/other properties
and methods of this control


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Jay" wrote:

I would like to know if it's possible to add a pull down
menu to a userform. I want to create a menu in my user
form and I don't want to add a custom menu to the
existing excel menu. I browsed the different controls
but I can't seem to find the one I need.

thinks for the help
Jay

Tom ..

I honestly dont know.

On my machine they work...
Most people will have m ...
If you're not distributing but just using what's there...

i'd be interested to know though.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Tom Ogilvy" wrote:

This appears to be one of the common controls - don't these require a
license for design time operation - the mode Office operates in?

I was referring to the Excel built in objects (commandbars).

Perhaps a thirdparty control can provide that functionality. In VB the
language, forms (which are not userforms) can have menus on them, so I was
really making a contrast to what can be done in VB vice VBA.

--
Regards,
Tom Ogilvy

"Jay" wrote in message
...
Thanks for your help guys; unfortunately I can find any
properties in the toolbar control or in any other
controls that could help me create a pull down menu.
It's quite possible that this particular object is not
supported in a userform as Tom pointed out.

Again thanks for the help
Jay.

-----Original Message-----
This appears to be one of the common controls - don't
these require a
license for design time operation - the mode Office
operates in?

--
Regards,
Tom Ogilvy

"keepitcool" wrote in message
.. .
in the VBEditor

Rightclick the Control Toolbox
Select additional controls..
try to find Microsoft Toolbar control

add it to the toolbox then drag into form.
now open properties window..
select the custom property to open the properties bag.

check object browser for more/other properties
and methods of this control


keepITcool

In order to work around this issue I decided to use the
toolbar control with an imageList control in order to
have icon instead of just text on my buttons.

So basically what I did is insert a couple of icon
picture in my imageList using the custom properties in
the Image tab and associate each picture index with a
key.

Normally the only thing left to do would be associate the
toolbar with the imageList by going on the Toolbar
property window, and in the imageList drop down, select
the name of the imageList control ex:(myImageList). But
I have nothing on that list but "none" as if I didn't add
an imageList on my userform. I tried to see if I needed
to set other options in order to see myImageList object
in the list but I did find any.

This is quite frustrating and I would appreciate any
suggestion that would help me bypass the problem.

Thanks. Jay


-----Original Message-----
I was referring to the Excel built in objects
(commandbars).

Perhaps a thirdparty control can provide that
functionality. In VB the
language, forms (which are not userforms) can have menus
on them, so I was
really making a contrast to what can be done in VB vice
VBA.

--
Regards,
Tom Ogilvy

no need to have an imagelist, you can set the picture property of any
button or frame or label on a userform with loadpicture
(stdole.stdfunctions)

btn.picture=loadpicture(filename, width,height)


Although I'm just discovering all those common controls I noted that
an imagelist by itself wont display on a form.

You can create it (also as a temp variable in code )

dim oImgList as NEW imageList

it seems to serve merely as a container for several other controls like
treeviews or listviews. ... or something...

but it DOES have the option to OVERLAY images.. which was really the
only functionality I was interested in at the time... didn't want to be
bothered by lots of api stuff and copying to the clipboard etc.



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Jay" wrote:

In order to work around this issue I decided to use the
toolbar control with an imageList control in order to
have icon instead of just text on my buttons.

So basically what I did is insert a couple of icon
picture in my imageList using the custom properties in
the Image tab and associate each picture index with a
key.

Normally the only thing left to do would be associate the
toolbar with the imageList by going on the Toolbar
property window, and in the imageList drop down, select
the name of the imageList control ex:(myImageList). But
I have nothing on that list but "none" as if I didn't add
an imageList on my userform. I tried to see if I needed
to set other options in order to see myImageList object
in the list but I did find any.

This is quite frustrating and I would appreciate any
suggestion that would help me bypass the problem.

Thanks. Jay


-----Original Message-----
I was referring to the Excel built in objects
(commandbars).

Perhaps a thirdparty control can provide that
functionality. In VB the
language, forms (which are not userforms) can have menus
on them, so I was
really making a contrast to what can be done in VB vice
VBA.