Try:

..Caption = Range("menu1")

--

Vasant

"Tony" wrote in message
...
Thank you for your suggestion but I need a bit more help to have it
working.
When in my code I am refering to the range containing my text the toolbar
is
displaying nothing. My code looks like

.Caption = menu1

where menu1 is the name of the range with the text to be displayed on the
custome menu. I have tried all different combination and I can not have
any
text. My old line of code which displayed the text was:

.Caption = "My menu"

If menu1 contain text why the text is not displayed ??? Please help.

Regards,

Tony

"keepITcool" wrote:

Since it's probably unicode text, iso copying them as constants in VBA
why not copy them to a range on a (hidden) sheet,
and read them from there when you create the toolbar.

makes maintenance a lot easier too.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Tony wrote :

I need to create custom menu with captions using english and
non-english characters, or if this is not possible just non-english
characters. How in my code I can enter required text containing
non-english characters ? When I am copying my translated caption from
Word and pasting into my code it is giving me ????. Is it possible to
do what I need ? How ?

Thanks for help.

Tony