Thread: Help with VBA Capitalization
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Help with VBA Capitalization
summaryTitle = UCase((ctrl.Caption) & " AAV SUMMARY")
--
Gary''s Student - gsnu200906


"Ayo" wrote:

How do I convert ctrl.Caption to all CAP?

summaryTitle = (ctrl.Caption) & " AAV SUMMARY"
Reply With QuoteReply With Quote