change text to uppercase

[coopman64]

I'm creating a schedule template and with much help from the members of excel forum, I almost have it finished. I finally have the macro fixed to input the day and date, but it's in proper case and I'm trying to convert it to uppercase. I've tried several ideas that I've found on the internet but nothing works. Here's the code that inputs the day and date. Can anyone tell me what I need to add to get upper case?

Please Login or Register  to view this content.

[TMS]

Use UCase


Regards, TMS

[alansidman]

Here is some code for you to examine.

Please Login or Register  to view this content.

Note that two lines are commented out. Pick the one you want and change it.

Alan

[coopman64]

alanskiman, I want to put it in the same macro so that when i create the schedules, I just have to run one macro. Do I wrap that around my code that dates the sheets?

[alansidman]

Without seeing your entire code, I cannot tell you where to place my code. I'm sure its just a case of putting them in the proper order.

Alan

[coopman64]

I just stepped through the macro and it changes the names in the schedule but not the day and date. Specifically, I just need to change cells a1 and g1 to upper case

[coopman64]

Heres the macro. All I need to do is make the day and date all uppercase and nothing works