将月份名称转换成数字 [英] Convert month name into number
本文介绍了将月份名称转换成数字的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
例如。 9月= 9
解决方案
另一种方式
Excel公式
= MONTH(1& A1)
VBA
Sub Sample()
Dim MonthNm As String
MonthNm =September
Debug.Print Month(DateValue(01& MonthNm&2012))
End Sub
或
Sub Sample()
Dim MonthNm As String
MonthNm =September
Debug.Print Application.Evaluate(= MONTH(1&& Chr(34)& MonthNm& ; Chr(34)&))
End Sub
替换
I have dropdown box with months populated. When a month is selected I would like to then convert it to the month number is there a function that can do this?
Eg. September = 9
解决方案
Another way
Excel Formula
=MONTH(1&A1)
VBA
Sub Sample()
Dim MonthNm As String
MonthNm = "September"
Debug.Print Month(DateValue("01 " & MonthNm & " 2012"))
End Sub
or
Sub Sample()
Dim MonthNm As String
MonthNm = "September"
Debug.Print Application.Evaluate("=MONTH(1&" & Chr(34) & MonthNm & Chr(34) & ")")
End Sub
Replace
这篇关于将月份名称转换成数字的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文