View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Desert Piranha[_112_] Desert Piranha[_112_] is offline
external usenet poster
 
Posts: 1
Default Optional Variant


NickHK Wrote:
At a guess, you are refering the .Add method.
<From Help
Add Method (CommandBars Collection)
Creates a new command bar and adds it to the collection of command
bars.
Returns a CommandBar object.
Syntax
expression.Add(Name, Position, MenuBar, Temporary)
expression Required. An expression that returns a CommandBars
object.
Name Optional Variant. The name of the new command bar. If this
argument is omitted, a default name is assigned to the command bar
(such as
"Custom 1").
...... etc
</From Help

As in the explanation, "Optional" refers to the fact that you do not
have
the supply this argument. If you do, then it is used for the Name, if
not, a
default is supplied.
As for the "Variant" part, you can basically supply an data type, as
long as
it's value can be coerced into a valid value for Name.

NickHKHi Nick,


So its nothing i need to be concerned with, as i work with
CommandBars.
I either name them (which i would) or i don't, and don't worry about
it..


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=574363