VBA question

  • Thread starter Thread starter Edward
  • Start date Start date
E

Edward

Does anyone know about msoTriStateToggle ,msoTriStateMixed, msoCtrue . Often
we have these three additional options among with True False. I remember once
I read about them somewhere in VBA help but I can't find it now, so I would
appreciate if someone can tel me the diffrence between these three options.
 
here we have all the 5 options for bullet
oShp.Table.Cell(i, j).Shape.TextFrame.TextRange .ParagraphFormat.Bullet =
msoTrue

--
Best regards,
Edward


Austin Myers said:
Edward,

It all depends which "object" and which "properties" you are talking about.


Austin Myers
AT&W Technologies

www.playcsforcertain.com
Creators of PowerPoint add-ins
Click to expand...
 
In that case you have msoTrue, msoFalse, and msoToggle meaning it can be
altered by code or an action setting like a trigger. Hmm, you could also
have msoMixed, say where you have the text in an Arial Font but the bullet
is another font.


Austin Myers
AT&W Technologies

www.playcsforcertain.com
Creators of PowerPoint add-ins



Edward said:
here we have all the 5 options for bullet
oShp.Table.Cell(i, j).Shape.TextFrame.TextRange .ParagraphFormat.Bullet =
msoTrue
Click to expand...
 
Thanks, but what do you exactly mean by altered by code or an action
settings? I mean I don't see any diffrence when I use msoToggle or msoTrue in
both cases I can easly remove the bullet by code.
 
Edward said:
Thanks, but what do you exactly mean by altered by code or an action
settings? I mean I don't see any diffrence when I use msoToggle or msoTrue
in
both cases I can easly remove the bullet by code.
Click to expand...

You could for example use a MS Toggle control.



Austin Myers
AT&W Technologies

www.playcsforcertain.com
Creators of PowerPoint add-ins
 
I was joking about the toggle button. I had a "smiley face" on it but it
didn't show up in the post. (red-faced)



After doing some reading I don't believe mixed or toggle are supported in
the office.dll itself.


Austin Myers
AT&W Technologies

www.playcsforcertain.com
Creators of PowerPoint add-ins
 
Exactly, I tested this after I posted my question and as you mentioned toggle
is acctually very useful because it toggles betweens true and false , and for
mixed again as you mentioned its most useful if we use it for checking things
like
if ......bullet=mixed then ....
Thanks again
 
Back
Top