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?
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?
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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks