Discussion:
Transparent VBA text box is opaque when presenting
(too old to reply)
StrangerCoug
2006-09-24 01:15:01 UTC
Permalink
I have PowerPoint 2003 and I selected two VBA text boxes to be transparent.
However, when I run the presentation, they come out opaque. What's wrong?
John Wilson
2006-09-24 08:49:01 UTC
Permalink
The transparent background will only work in slide show mode if the box is on
a vba form which I guess is not what you want.

To make a control text box background "blend in" you need to set both the
backcolor and border color to be the same as the background** and set border
style to 1-fm border stylesingle
--
(I'm assuming that you know how the hex colour codes correspond to the RGB
color of the background - get back if you don't)

Did that answer the question / help?
_____________________________
John Wilson
Microsoft Certified Office Specialist
http://www.technologytrish.co.uk/ppttipshome.html
Post by StrangerCoug
I have PowerPoint 2003 and I selected two VBA text boxes to be transparent.
However, when I run the presentation, they come out opaque. What's wrong?
StrangerCoug
2006-09-24 15:02:01 UTC
Permalink
It works in the short run.

What I had in mind was that I have a seven-segment font (like what you see
on a digital clock) that I want to use as the font for the text box. Behind
it in a darker color and the same font and size is a series of eights. I
wanted to make it look like the segments are turned on or off to make the
number (I'm using it for scorekeeping purposes and know how to increase or
decrease it by a set amount).

Any workarounds as to putting this and the buttons to change the number in a
(preferably stationary) VBA form? Keep in mind that it is to be displayed on
the slide at all times. (How do you make a VBA form anyway?)
Post by John Wilson
The transparent background will only work in slide show mode if the box is on
a vba form which I guess is not what you want.
To make a control text box background "blend in" you need to set both the
backcolor and border color to be the same as the background** and set border
style to 1-fm border stylesingle
--
(I'm assuming that you know how the hex colour codes correspond to the RGB
color of the background - get back if you don't)
Did that answer the question / help?
_____________________________
John Wilson
Microsoft Certified Office Specialist
http://www.technologytrish.co.uk/ppttipshome.html
Post by StrangerCoug
I have PowerPoint 2003 and I selected two VBA text boxes to be transparent.
However, when I run the presentation, they come out opaque. What's wrong?
John Wilson
2006-09-24 15:29:02 UTC
Permalink
This probably wont help as you really need to know vba to use a userform. But
to create one go to the vb editor (alt + f11) and insert user form and add
whatever from the control toolbox

To display it in your pres create a command button, right click >view code
and add the code between the lines already there

load userform1
userform1.show
--
Did that answer the question / help?
_____________________________
John Wilson
Microsoft Certified Office Specialist
http://www.technologytrish.co.uk/ppttipshome.html
Post by StrangerCoug
It works in the short run.
What I had in mind was that I have a seven-segment font (like what you see
on a digital clock) that I want to use as the font for the text box. Behind
it in a darker color and the same font and size is a series of eights. I
wanted to make it look like the segments are turned on or off to make the
number (I'm using it for scorekeeping purposes and know how to increase or
decrease it by a set amount).
Any workarounds as to putting this and the buttons to change the number in a
(preferably stationary) VBA form? Keep in mind that it is to be displayed on
the slide at all times. (How do you make a VBA form anyway?)
Post by John Wilson
The transparent background will only work in slide show mode if the box is on
a vba form which I guess is not what you want.
To make a control text box background "blend in" you need to set both the
backcolor and border color to be the same as the background** and set border
style to 1-fm border stylesingle
--
(I'm assuming that you know how the hex colour codes correspond to the RGB
color of the background - get back if you don't)
Did that answer the question / help?
_____________________________
John Wilson
Microsoft Certified Office Specialist
http://www.technologytrish.co.uk/ppttipshome.html
Post by StrangerCoug
I have PowerPoint 2003 and I selected two VBA text boxes to be transparent.
However, when I run the presentation, they come out opaque. What's wrong?
StrangerCoug
2006-09-24 18:05:02 UTC
Permalink
I'll probably just use the blend-in mentioned in the first reply. I really
need to learn VBA for this!
Post by John Wilson
This probably wont help as you really need to know vba to use a userform. But
to create one go to the vb editor (alt + f11) and insert user form and add
whatever from the control toolbox
To display it in your pres create a command button, right click >view code
and add the code between the lines already there
load userform1
userform1.show
--
Did that answer the question / help?
_____________________________
John Wilson
Microsoft Certified Office Specialist
http://www.technologytrish.co.uk/ppttipshome.html
Post by StrangerCoug
It works in the short run.
What I had in mind was that I have a seven-segment font (like what you see
on a digital clock) that I want to use as the font for the text box. Behind
it in a darker color and the same font and size is a series of eights. I
wanted to make it look like the segments are turned on or off to make the
number (I'm using it for scorekeeping purposes and know how to increase or
decrease it by a set amount).
Any workarounds as to putting this and the buttons to change the number in a
(preferably stationary) VBA form? Keep in mind that it is to be displayed on
the slide at all times. (How do you make a VBA form anyway?)
Post by John Wilson
The transparent background will only work in slide show mode if the box is on
a vba form which I guess is not what you want.
To make a control text box background "blend in" you need to set both the
backcolor and border color to be the same as the background** and set border
style to 1-fm border stylesingle
--
(I'm assuming that you know how the hex colour codes correspond to the RGB
color of the background - get back if you don't)
Did that answer the question / help?
_____________________________
John Wilson
Microsoft Certified Office Specialist
http://www.technologytrish.co.uk/ppttipshome.html
Post by StrangerCoug
I have PowerPoint 2003 and I selected two VBA text boxes to be transparent.
However, when I run the presentation, they come out opaque. What's wrong?
StrangerCoug
2006-09-24 18:36:02 UTC
Permalink
I think I have it figured out now. I used one with dark 8's and another with
the score on top. Thanks!
Post by John Wilson
This probably wont help as you really need to know vba to use a userform. But
to create one go to the vb editor (alt + f11) and insert user form and add
whatever from the control toolbox
To display it in your pres create a command button, right click >view code
and add the code between the lines already there
load userform1
userform1.show
--
Did that answer the question / help?
_____________________________
John Wilson
Microsoft Certified Office Specialist
http://www.technologytrish.co.uk/ppttipshome.html
Post by StrangerCoug
It works in the short run.
What I had in mind was that I have a seven-segment font (like what you see
on a digital clock) that I want to use as the font for the text box. Behind
it in a darker color and the same font and size is a series of eights. I
wanted to make it look like the segments are turned on or off to make the
number (I'm using it for scorekeeping purposes and know how to increase or
decrease it by a set amount).
Any workarounds as to putting this and the buttons to change the number in a
(preferably stationary) VBA form? Keep in mind that it is to be displayed on
the slide at all times. (How do you make a VBA form anyway?)
Post by John Wilson
The transparent background will only work in slide show mode if the box is on
a vba form which I guess is not what you want.
To make a control text box background "blend in" you need to set both the
backcolor and border color to be the same as the background** and set border
style to 1-fm border stylesingle
--
(I'm assuming that you know how the hex colour codes correspond to the RGB
color of the background - get back if you don't)
Did that answer the question / help?
_____________________________
John Wilson
Microsoft Certified Office Specialist
http://www.technologytrish.co.uk/ppttipshome.html
Post by StrangerCoug
I have PowerPoint 2003 and I selected two VBA text boxes to be transparent.
However, when I run the presentation, they come out opaque. What's wrong?
Steve Rindsberg
2006-09-24 16:07:27 UTC
Permalink
Could you accomplish the same thing by using a normal PPT text box rather than an
ActiveX text box control?
Post by StrangerCoug
It works in the short run.
What I had in mind was that I have a seven-segment font (like what you see
on a digital clock) that I want to use as the font for the text box. Behind
it in a darker color and the same font and size is a series of eights. I
wanted to make it look like the segments are turned on or off to make the
number (I'm using it for scorekeeping purposes and know how to increase or
decrease it by a set amount).
Any workarounds as to putting this and the buttons to change the number in a
(preferably stationary) VBA form? Keep in mind that it is to be displayed on
the slide at all times. (How do you make a VBA form anyway?)
Post by John Wilson
The transparent background will only work in slide show mode if the box is on
a vba form which I guess is not what you want.
To make a control text box background "blend in" you need to set both the
backcolor and border color to be the same as the background** and set border
style to 1-fm border stylesingle
--
(I'm assuming that you know how the hex colour codes correspond to the RGB
color of the background - get back if you don't)
Did that answer the question / help?
_____________________________
John Wilson
Microsoft Certified Office Specialist
http://www.technologytrish.co.uk/ppttipshome.html
Post by StrangerCoug
I have PowerPoint 2003 and I selected two VBA text boxes to be transparent.
However, when I run the presentation, they come out opaque. What's wrong?
-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
StrangerCoug
2006-09-24 18:06:02 UTC
Permalink
No - the number needs to be changed during the presentation by the buttons I
described in the third post.
Post by Steve Rindsberg
Could you accomplish the same thing by using a normal PPT text box rather than an
ActiveX text box control?
Post by StrangerCoug
It works in the short run.
What I had in mind was that I have a seven-segment font (like what you see
on a digital clock) that I want to use as the font for the text box. Behind
it in a darker color and the same font and size is a series of eights. I
wanted to make it look like the segments are turned on or off to make the
number (I'm using it for scorekeeping purposes and know how to increase or
decrease it by a set amount).
Any workarounds as to putting this and the buttons to change the number in a
(preferably stationary) VBA form? Keep in mind that it is to be displayed on
the slide at all times. (How do you make a VBA form anyway?)
Post by John Wilson
The transparent background will only work in slide show mode if the box is on
a vba form which I guess is not what you want.
To make a control text box background "blend in" you need to set both the
backcolor and border color to be the same as the background** and set border
style to 1-fm border stylesingle
--
(I'm assuming that you know how the hex colour codes correspond to the RGB
color of the background - get back if you don't)
Did that answer the question / help?
_____________________________
John Wilson
Microsoft Certified Office Specialist
http://www.technologytrish.co.uk/ppttipshome.html
Post by StrangerCoug
I have PowerPoint 2003 and I selected two VBA text boxes to be transparent.
However, when I run the presentation, they come out opaque. What's wrong?
-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Bill Dilworth
2006-09-24 22:13:54 UTC
Permalink
ActiveX controls often have problems with transparency. I think you might
be best avoiding it in this case. A regular textbox can be controled via
VBA as easily as an ActiveX one can (my experience has been that regular
textboxes are easier than ActiveX ones), as long as you know the name of it.
This is what and why Steve was suggesting the change.

The regular textbox with the dark 8's behind the regular transparent-fill
textbox with the red-segment numbers works well on this end.
--
Bill Dilworth
A proud member of the Microsoft PPT MVP Team
Users helping fellow users.
billdilworth.mvps.org
-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_
yahoo2@ Please read the PowerPoint
yahoo. FAQ pages. They answer most
com of our questions.
www.pptfaq.com
.
.
Post by StrangerCoug
No - the number needs to be changed during the presentation by the buttons I
described in the third post.
Post by Steve Rindsberg
Could you accomplish the same thing by using a normal PPT text box rather than an
ActiveX text box control?
Post by StrangerCoug
It works in the short run.
What I had in mind was that I have a seven-segment font (like what you see
on a digital clock) that I want to use as the font for the text box. Behind
it in a darker color and the same font and size is a series of eights. I
wanted to make it look like the segments are turned on or off to make the
number (I'm using it for scorekeeping purposes and know how to increase or
decrease it by a set amount).
Any workarounds as to putting this and the buttons to change the number in a
(preferably stationary) VBA form? Keep in mind that it is to be displayed on
the slide at all times. (How do you make a VBA form anyway?)
Post by John Wilson
The transparent background will only work in slide show mode if the box is on
a vba form which I guess is not what you want.
To make a control text box background "blend in" you need to set both the
backcolor and border color to be the same as the background** and set border
style to 1-fm border stylesingle
--
(I'm assuming that you know how the hex colour codes correspond to the RGB
color of the background - get back if you don't)
Did that answer the question / help?
_____________________________
John Wilson
Microsoft Certified Office Specialist
http://www.technologytrish.co.uk/ppttipshome.html
Post by StrangerCoug
I have PowerPoint 2003 and I selected two VBA text boxes to be transparent.
However, when I run the presentation, they come out opaque. What's wrong?
-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Steve Rindsberg
2006-09-24 23:18:46 UTC
Permalink
Post by StrangerCoug
No - the number needs to be changed during the presentation by the buttons I
described in the third post.
No reason why the text in normal text boxes can't be changed during the presentation.
It's no more complicated than changing the text in textbox controls.

If you name them ahead of time, you can do something as simple as:

With ActivePresentation.Slides(x).Shapes("LCDReadout")
.TextFrame.TextRange.Text = "0001"
End With

(substitute the number of the slide you want for X above)

Or have a look here ... I've cobbled up a quick example with all the needed code

An "LCD" counter that you can change
http://www.pptfaq.com/FAQ00817.htm
Post by StrangerCoug
Post by Steve Rindsberg
Could you accomplish the same thing by using a normal PPT text box rather than an
ActiveX text box control?
Post by StrangerCoug
It works in the short run.
What I had in mind was that I have a seven-segment font (like what you see
on a digital clock) that I want to use as the font for the text box. Behind
it in a darker color and the same font and size is a series of eights. I
wanted to make it look like the segments are turned on or off to make the
number (I'm using it for scorekeeping purposes and know how to increase or
decrease it by a set amount).
Any workarounds as to putting this and the buttons to change the number in a
(preferably stationary) VBA form? Keep in mind that it is to be displayed on
the slide at all times. (How do you make a VBA form anyway?)
Post by John Wilson
The transparent background will only work in slide show mode if the box is on
a vba form which I guess is not what you want.
To make a control text box background "blend in" you need to set both the
backcolor and border color to be the same as the background** and set border
style to 1-fm border stylesingle
--
(I'm assuming that you know how the hex colour codes correspond to the RGB
color of the background - get back if you don't)
Did that answer the question / help?
_____________________________
John Wilson
Microsoft Certified Office Specialist
http://www.technologytrish.co.uk/ppttipshome.html
Post by StrangerCoug
I have PowerPoint 2003 and I selected two VBA text boxes to be transparent.
However, when I run the presentation, they come out opaque. What's wrong?
-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

Loading...