overlapping picture problem
 

hi all

i've put textboxes and other stuff in a userform, but if i want to pu
some pictures in also for my background, the pictures overlap all th
rest. how can i put the pictures in come order that one is backgroun
and the other isn't

--
tomro
-----------------------------------------------------------------------
tomro1's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread.php?threadid=57313

overlapping picture problem
 

Turn on the macro recorder.

Right click on one of the pictures and select send to the back. Turn off
the macro recorder and look at the code.

I get:

Selection.ShapeRange.ZOrder msoSendToBack

this should get you started.

--
Regards,
Tom Ogilvy


"tomro1" wrote:


hi all

i've put textboxes and other stuff in a userform, but if i want to put
some pictures in also for my background, the pictures overlap all the
rest. how can i put the pictures in come order that one is background
and the other isn't?


--
tomro1
------------------------------------------------------------------------
tomro1's Profile: http://www.excelforum.com/member.php...o&userid=35081
View this thread: http://www.excelforum.com/showthread...hreadid=573138