Help with VBA Capitalization

  • Thread starter Thread starter Ayo
  • Start date Start date
A

Ayo

How do I convert ctrl.Caption to all CAP?

summaryTitle = (ctrl.Caption) & " AAV SUMMARY"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Right Click Menu not working when sheet is in Page Break Preview m 7
differentiating between checkboxes 7
AllowEdits Toggle button not working 2
List Visible Controls in CommandBars("Worksheet Menu Bar") 3
Help with Run-time error '1004': Method 'Range' of object'_Workshe 1
select case statement? 5
Need More Help on Stuffing Checkbox control 3
Sub-menus for Right Click add ins 2

Back
Top