Hello,
I normally had this code place in “thisWorkbook” but is there anyway to place this in the VBAP project in Sheet2 instead. The reason, there is a lot of codes going on thisWorkbook that I don’t want to be affected.
Can anyone probably edit the code so I can place it in the Sheet2 only.
My target range in Sheet2 are just the cell AU5 and U6.
This code will auto upper case my entry in AU5 and U6 only
Thank you.
Please Login or Register to view this content.
If I understand you correctly, you want anything entered in AU5 or U6 to be upper case, anything entered elsewhere to be proper case?
Edit: also, I think you want code for the Worksheet not Workbook - the code below should go in the VBE for Sheet2 (or any other sheet you want it to work on)
Try this:
Please Login or Register to view this content.
Last edited by Aardigspook; 11-01-2018 at 01:02 PM. Reason: Clarification
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
Maybe:
Please Login or Register to view this content.
Last edited by xladept; 11-01-2018 at 01:17 PM.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thank you all.
You're welcome!
You're welcome, glad we could help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks