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

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