Make macro work with upper case and lower case

**Caitlin535** · 11-06-2019, 12:37 PM

Hello! I have the following Macro (below) in a spreadsheet I use to record work times for my employees. In column C there is a dropdown in which they are supposed to choose "ARRIVED," and then a timestamp appears in both column D and P. Similar for column E - they're supposed to select "DEPARTED" from a dropdown menu and then it enters a timestamp in both column F and Q.

The trouble is, sometimes employees type "Arrived" or "Departed" instead of using the dropdowns. Because these are the correct words the dropdown error function doesn't alert, but unfortunately the Macro doesn't run. Is there a way to make the Macro not case-dependent?

Thanks!

Please Login or Register  to view this content.

**shg** · 11-06-2019, 12:41 PM

Welcome to the board.

Please take a few minutes to read the Forum Rules, and then edit your post to wrap your code with CODE tags.

Thanks.

**Pete_UK** · 11-06-2019, 12:44 PM

Can't you use UCASE(Target.Value) on the appropriate lines?

By the way, you should put code tags around your code - refer to the Forum Rules at the top of the screen.

Hope this helps.

Pete

**Caitlin535** · 11-06-2019, 12:56 PM

Apologies - I did read the rules, but then forgot! Corrected now.

**nigelog** · 11-06-2019, 12:58 PM

Could you not use validation and a dropdown to select "ARRIVED" and "DEPARTED"

**Caitlin535** · 11-06-2019, 12:58 PM

Hi Pete_UK -
I suspect I can, but I'm an *infant* when it comes to VBA code (although this is how I'm learning it) - could you please just clarify where I would put UCASE(Target.value)?

And yes, I apologize for initially not putting in code tags - I've corrected it. Apologies!

**Fluff13** · 11-06-2019, 12:59 PM

Try having a look on the other site you have asked this question.

Also please read the rules & supply the relevant cross post link.
Thanks

**Caitlin535** · 11-06-2019, 12:59 PM

Yes, that's exactly what I do - dropdowns with the options "ARRIVED" on one and "DEPARTED" in the other. I have it set to give a "Stop" error message when any other data is entered in the cell, but it seems that Excel doesn't recognize "Arrived" (or conversely, "Departed") as invalid. It seems like the List data validation isn't case-dependent.

**Norie** · 11-06-2019, 01:00 PM

Use UCase (or LCase) on both the value you want to check and the value you want to check against.

Please Login or Register  to view this content.

**shg** · 11-06-2019, 01:02 PM

Or just add Option Compare Text at the top of the module.

**Caitlin535** · 11-06-2019, 01:16 PM

Apologies to everyone - I initially hadn't realized I was posting on not my usual site (MrExcel.com), and then posted this question over there as well, where it has been answered.
I've tried posting the link here, but it actually won't allow me to post links until I've posted a few times.
Again, I'm so sorry for the inadvertent cross-posting, but thank you all so very much for your help!

**Fluff13** · 11-06-2019, 01:19 PM

As the OP can't post links, it's here https://www.mrexcel.com/forum/excel-...ower-case.html

Make macro work with upper case and lower case

LinkBack

Thread Tools

Rate This Thread

Display

Make macro work with upper case and lower case

Re: Make macro work with upper case and lower case

Re: Make macro work with upper case and lower case

Re: Make macro work with upper case and lower case

Re: Make macro work with upper case and lower case

Re: Make macro work with upper case and lower case

Re: Make macro work with upper case and lower case

Re: Make macro work with upper case and lower case

Re: Make macro work with upper case and lower case

Re: Make macro work with upper case and lower case

Re: Make macro work with upper case and lower case

Re: Make macro work with upper case and lower case

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Change name format including adjusting upper case to lower case

Need to extract UPPER CASE text from the right until it find lower case or number

[SOLVED] Help needed with a formula to convert upper-case words only to lower-case

[SOLVED] Lower Case to Upper Case but No Auto Correction : Solved by Mod (6StringJazzer)

Make Upper Case in cells become lower case

Change the text from lower case to upper case in an Excel work boo

[SOLVED] Changing file in all upper case to upper and lower case

Bookmarks

Bookmarks

Posting Permissions