LinkBack URL
About LinkBacks
I have several shortcuts that I use for inserting text. Sometimes it needs to be capitalized......how do I set it up to do this automatically?
I have several shortcuts that I use for inserting text. Sometimes it needs to be capitalized......how do I set it up to do this automatically?
Last edited by oskie89; 08-03-2012 at 03:46 PM.
Hi
So, You use any code (VBA) in those shortcuts or what?
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
try this formula
=UPPER(LEFT(A1,1))&RIGHT(A1,LEN(A1)-1)
to get vba code, just put this formula into your code, with something Range("A1") instead of A1 in my formula
You can use this code to get the job done.
Please Login or Register to view this content.
Last edited by day92; 08-04-2012 at 12:51 AM.
No codes, just shortcuts on typing text......tog for topography, cr for crop, pas for pasture, etc.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks