PDA

View Full Version : Solved: Help... Excel VBA Problem



Joker12
11-06-2005, 04:42 PM
I'd like to use an image control to place a gif on a userform. I would then like to print messages on top of the image in various colors through VBA.

Is this possible or am I barking into the wind using excel???

I've done some extensive searching and have come up with nada:(

Joker12

Forget it, I have figured it out, so simple.

malik641
11-06-2005, 11:04 PM
Hey joker, just wanted to welcome you to VBAX :hi:

BTW, If your thread is resolved, mark it so by selecting "Mark Thread Solved" in the thread tools :thumb

sheeeng
11-07-2005, 04:58 AM
Hi Joker12, Welcome to VBAX.
I'm not sure whether that is possible or not...
Have to wait for other more experienced ones to giv some tips...

Joker12
11-07-2005, 06:33 AM
Hi Guys

@Malik641 I thought I did, Sorry.

@sheeng I put the image control on the userform. I then put a textbox control over the image and set the backstyle to transparent. Changed the color of the text and volia! Now I can control the text shown over the image.

Joker12

sheeeng
11-07-2005, 06:38 AM
You are welcome. Hope to hear more from you in VBAX in future.

sheeeng
11-07-2005, 06:41 AM
BTW, If your thread is resolved, mark it so by selecting "Mark Thread Solved" in the thread tools :thumb

Joker12, Please mark your thread solved before you forget. This make the forum more manageable and tidy. :friends:

Thx in advance.