Make macro work with upper case and lower case

[Caitlin535]

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]

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]

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]

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

[nigelog]

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

[Caitlin535]

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]

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]

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]

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]

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

[Caitlin535]

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]

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