ExcelBanter - Help with VBA Capitalization

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Help with VBA Capitalization (https://www.excelbanter.com/excel-programming/434483-help-vba-capitalization.html)

Ayo

Help with VBA Capitalization

How do I convert ctrl.Caption to all CAP?

summaryTitle = (ctrl.Caption) & " AAV SUMMARY"

Gary''s Student

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"

All times are GMT +1. The time now is 04:16 AM.