Accepting common and/or capitals in an excel macro 1

[vaughn9]

Here is part of my macro

dim data1 as string

data1=inputbox("Select a day of the week M/T/W/TH/F&quot
If data1="M" then
msgbox("Monday&quot
Else
etc
etc
etc

My question is how can I get the programme to accept both common and capitals. Right now it is only accepting capitals


Also can I change the label name Microsoft excel that appears to the top left of a input box?

 

[sfvb]

data1 = InputBox("Select a day of the week M/T/W/TH/F", "My Title&quot
If UCase(data1) = "M" Then
...

 

[ETID]

Or....
data1=ucase(inputbox("Select a day of the week M/T/W/TH/F&quot)