Not getting correct output in message

[mso3]

Hello friends,

I used a input box to enter the number of month to filter which is working fine.
I set the filtermonth as string

I want a message at the end of macro as follows:
Wrong message getting now:
Congratulation! The birthday list of 8 August is ready.
Correct message output require:
Congratulation! The birthday list of August is ready.

Please Login or Register  to view this content.

But now I’m getting a month number as well as month name in the message. I don’t want the month number in the message. I want only the month name in the message.

Thanking you,

[Norie]

Remove this part,

Please Login or Register  to view this content.

and if you want the month name based on what the user has entered use this.

Please Login or Register  to view this content.

So.

Please Login or Register  to view this content.

[Ron Coderre]

Try something like this

Please Login or Register  to view this content.

Is that something you can work with?

[Ron Coderre]

I keep forgetting about MonthName, Norie.
Thanks for the reminder.

[mso3]

Hi Norie and Ron,
Norie, Perfect! It's working fine.

Ron, No, It's showing wrong month. Don't mind. My problem is solved.

Thank you to both of you.

Have a nice day.