View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anthony Berglas Anthony Berglas is offline
external usenet poster
 
Posts: 23
Default Multiple fonts in a VBA UserForm label (to make XL 95 form non-modal)

I want to convert an XL 95 style form to a VBA user form so that it
can be non-modal. However, I also need to be able to have multiple
fonts within the label. Ie what could be done with DrawingObject|
Shape.Characters.Font.

I suspect that this is not possible in a relatively clean way.
AndyPope.info uses some code by Steve Bullen to make images out of
shapes cut to the clipboard using Win32 calls -- much black magic and
rather slow. There are also third party Active X controls, but that
would complicate my install -- 100% VBA is nice.

Any ideas most welcome.

Anthony