Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 238
Default ToolBar Question

What does this doat the top of a Toolbar?

Option Explicit
Public Const ToolBarName As String = "MyToolbarName"
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,420
Default 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"



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 238
Default 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"
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,420
Default 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"



Reply
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
Toolbar question Jennifer H[_2_] Excel Worksheet Functions 5 March 27th 10 11:27 AM
Add-In Toolbar Control - Removing The Toolbar Question Dreiding Excel Programming 10 October 5th 07 06:39 PM
Toolbar question Doug Lowe Excel Programming 0 July 26th 06 06:26 PM
Menu /toolbar question Alan M Excel Programming 1 September 7th 05 07:09 PM
question about toolbar corruption Brian Murphy[_2_] Excel Programming 3 November 12th 04 02:00 AM


All times are GMT +1. The time now is 04:55 AM.

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

About Us

"It's about Microsoft Excel"