Thread: Label in a form
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Label in a form

Hi,

If the text is static consider using an image. Use autoshape textbox and
change alignment.
The copy the textbox as picture. Select textbox. Whilst holding shift use
menu, Edit Copy Picture Bmp.

Then within your userform add a Image or Label. Select the Picture property
and paste.

If the text is dynamic then there is code here to create/copy/paste shape on
the fly
http://www.andypope.info/vba/userformdraw.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"alvin Kuiper" wrote in message
...
Hi
Is there away to rotet a text in a label 90 degres ?

Alvin