text over image

P

pabs

here's my problem

I'm trying to generate raffle tickets with Excel

I have an image that is 3 inches by 7 inches.. that's the raffl
ticket.

on it I would like to add some text.. in particular two cells woul
contain teh ticket number.

I'll run a macro that will generate a ticket number and increment i
and print a page and keep looping for as many tickets as I need.

the problem I'm having is using a cell that is over the image..

any tricks>???

help!!?
 
R

Robin Hammond

Pabs,

Here's one idea. Place a text box (from the drawing toolbar) on top of your
image, format it so that it blends in nicely, then use something like this

Sub Macro1()
For ncounter = 1 To 100
ActiveSheet.Shapes("Text Box 1").Select
Selection.Characters.Text = CStr(ncounter) 'or whatever value you want
'PRINT HERE
Next ncounter
End Sub

Robin Hammond
www.enhanceddatasystems.com
 
N

NickHK

pabs,
Depending the style of your image, applying it as the background (Format -->
Sheet --> Background) then playing with column withs and row heights to get
the desired effect.

NickHK
 
D

Dsuperc

NickHK said:
pabs,
Depending the style of your image, applying it as the background (Format -->
Sheet --> Background) then playing with column withs and row heights to get
the desired effect.

NickHK
Click to expand...


Try this site www.XL-Logic.com and search for "WATERMARK"
 
Top