ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ToolBar Question (https://www.excelbanter.com/excel-programming/429953-toolbar-question.html)

Fan924

ToolBar Question
 
What does this doat the top of a Toolbar?

Option Explicit
Public Const ToolBarName As String = "MyToolbarName"

Bob Phillips[_3_]

ToolBar Question
 
You are referring to VBA code.

The Option Explicit tells VBA that all variables must be declared, which
helps avoid naming mistakes.

The Public Const is just creating a constant and loading it with a value. It
would seem that that constant will be used as the name of a toolbar created
later.

--
__________________________________
HTH

Bob

"Fan924" wrote in message
...
What does this doat the top of a Toolbar?

Option Explicit
Public Const ToolBarName As String = "MyToolbarName"




Fan924

ToolBar Question
 
If I create say 3 different toolbars, does this appear the same on all
3?

Option Explicit
Public Const ToolBarName As String = "MyToolbarName"


Or does each toolbar have a unique name?
"MyToolbarName"
"MyToolbarName2"
"MyToolbarName3"

Bob Phillips[_3_]

ToolBar Question
 
You can create one toolbar with many control buttons, or many toolbars, each
with many buttons.

--
__________________________________
HTH

Bob

"Fan924" wrote in message
...
If I create say 3 different toolbars, does this appear the same on all
3?

Option Explicit
Public Const ToolBarName As String = "MyToolbarName"


Or does each toolbar have a unique name?
"MyToolbarName"
"MyToolbarName2"
"MyToolbarName3"





All times are GMT +1. The time now is 11:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com