Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
command button add another command | Excel Discussion (Misc queries) | |||
LOOKUP Command Issue | Excel Worksheet Functions | |||
command button | New Users to Excel | |||
Command Button vs Control Button | Excel Programming | |||
Command Button vs Form Button | Excel Programming |