LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 125
Default Need help with Command Bar Button issue ??

Hi there,
I must apologize for posting in the excel programing news groups as this vba
code was writen in power point, howver Since it relates to command bar
buttons and forms and stuff I figured that it would be almost the same as
working with command bar buttons and forms in excel. (besides I could not
find a power point "programing" newsgroup)

Anyhow here is my code ....

Sub FloatingButton()
Dim MyBar
Dim MyControl
Set MyBar = CommandBars.Add(Name:="Custom", Position:=msoBarFloating,
MenuBar:=False, Temporary:=True)
Set MyControl = MyBar.Controls.Add(Type:=msoControlButton)
MyControl.Height = 15
MyControl.Width = 150
MyBar.Visible = True
MyControl.Caption = "There Should be Text on my button instead of this tool
tip ???"
End Sub

The problem I am having is that I want a single floating menu bar with one
button on it exactly the same idea as a regular command button on a form.
except for some stupid reason I can't get text to apear on the button itself.
And I would like the button on my floating menu bar to say "Click Me", but
the only text I can get to apear is tool tip text.

Any thoughts would be GREATLY appreciated!

Thanks in advance
Dan.

 
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
command button add another command Wanna Learn Excel Discussion (Misc queries) 5 December 7th 08 11:42 PM
LOOKUP Command Issue VegasBurger Excel Worksheet Functions 1 August 2nd 06 07:35 PM
command button Mike New Users to Excel 1 August 30th 05 01:39 AM
Command Button vs Control Button RGibson Excel Programming 1 October 14th 03 02:24 AM
Command Button vs Form Button T K Excel Programming 4 August 26th 03 07:26 PM


All times are GMT +1. The time now is 05:05 PM.

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

About Us

"It's about Microsoft Excel"