View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default Change Color of Caption in User form 2007

Those are set through the operating system, not on a per userform basis. You can always use a
textbox for a caption....

--
HTH,
Bernie
MS Excel MVP


"amit" wrote in message
...
hi - i need to format the caption section of the user form......particularly
change font type, change background color of the caption section and also
center the caption. i would ideally like this to happen during initialize and
so would put the code in Initialize sub.

thanks for your help