VBA Code to convert one variable as an Integer to a new variable as a month name

**rvgray** · 08-01-2017, 12:25 AM

Hello,

I am writing a macro and need help with a small portion. I want a variable titled EnteredMonth, which is defined as an Integer, to now be converted into a new variable titled EnteredMonthName. This new variable I want to display the name of the month according to the Integer that is inputted into my InputBox. Can anyone help me do this?

**karedog** · 08-01-2017, 12:50 AM

Maybe :

Please Login or Register  to view this content.

**rvgray** · 08-01-2017, 01:04 AM

Thank you!

**karedog** · 08-01-2017, 03:18 AM

You are welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

VBA Code to convert one variable as an Integer to a new variable as a month name

LinkBack

Thread Tools

Rate This Thread

Display

VBA Code to convert one variable as an Integer to a new variable as a month name

Re: VBA Code to convert one variable as an Integer to a new variable as a month name

Re: VBA Code to convert one variable as an Integer to a new variable as a month name

Re: VBA Code to convert one variable as an Integer to a new variable as a month name

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Convert two digit month (ex 10) to full Month Name in Variable

Reference Row in another workbook with integer variable

[SOLVED] Error in a Code. Object variable or With block variable not set????

[SOLVED] Excel VBA error code 91: Object variable or with block variable not set

Formatting a integer variable or something...

Error Code 91 Object Variable or With Block variable Not Set

Making sure variable is an integer?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions