I have figured out the VBA code to require text to be upper case if it is typed into the range of cells. The problem I am having is when someone copy/cuts and then pastes that text into the cell it will not make the code run. I am missing something somewhere.
any help is greatly appreciated.
Please Login or Register to view this content.
It should work if they copy-paste one cell.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
It does work for one cell. The problem is that multiple people will have access to this worksheet. The code pasted in the original post is just a small example of the entire code. The people with access to this worksheet will want to copy and paste multiple columns and rows at one time. If someone does this the current code don't work properly. Is there a way to make this code work under these parameters? Thanks for any help in advance.
You have told code to stop if Target is more than one cell. You may try:
Please Login or Register to view this content.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Try this...
Please Login or Register to view this content.
Thank you AlphaFrog. That works perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks