Hi, does anyone have a code that will convert a cell's text to Capitals?
The range that will be converted wouold be L10:L30.
by the way, this will be on multiple worksheets...
Thanks for any help on this...
Hi, does anyone have a code that will convert a cell's text to Capitals?
The range that will be converted wouold be L10:L30.
by the way, this will be on multiple worksheets...
Thanks for any help on this...
Megahertz
Hi,
This might help
VBA NoobPlease Login or Register to view this content.
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Hi VBAnoob, Sorry Just geeting back..
The Formula Works Great! I had to modify where I put it so it will update all
the sheets when the program is opened.. Is there a way to update as you
type in the cell it immediately changes to capital?
If not, The way I use it now will work ok.. Thanks for the Help
Hi,
This link should help
http://www.ozgrid.com/VBA/force-case-text.htm
VBA Noob
For a single sheet
'These instructions pre typed & are worded to cater for the novice programmer
'To install macro to correct location
'Copy this macro
'GoTo Excel
'Select sheet this is to appy to
'Right Click on Sheet Name Tab > select View Code
'Past macro into the Worksheet Module displayed
For all sheetsPlease Login or Register to view this content.
'These instructions pre typed & are worded to cater for the novice programmer
'To install macro to correct location
'Copy this macro
'GoTo Excel
'Open VB Editor by pressing Alt + F11
'Just below the menus & toolbars on the lsft you should see Project - VbaProject window
'In this window you will see ThisWorkbook
'double click on ThisWorkbook - opens ThisWorkbook module sheet
'Paste macro code into big window on right
Please Login or Register to view this content.
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assisted or failed to assist you I welcome your Feedback.
Thanks Mudraker Very Much!
Especially for the Novice as myself ... I'm still stuck in BASIC world..
The formula Works Flawlessly... Thanks For The Input.. It's Much Appreciated.
Thanks for the Link VBAnoob...
thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks