2020年6月7日
Excel VBA form code
摘要： Show UserForm When Excel File Opens https://contexturesblog.com/archives/2011/06/03/show-userform-when-excel-file-opens/ 阅读全文
posted @ 2020-06-07 21:19 emanlee 阅读(352) 评论(0) 推荐(0)
Excel VBA Chart.Export
摘要： ? REF: https://stackoverflow.com/questions/35098595/export-pictures-excel-vba-in-original-resolution https://stackoverflow.com/questions/49106816/how- 阅读全文
posted @ 2020-06-07 20:42 emanlee 阅读(1078) 评论(0) 推荐(0)
Excel VBA Chart 刻度 Axis.DisplayUnit
摘要： With Sheets("Report").ChartObjects.Add(...) .Chart.Axes(xlCategory).MinimumScale = RoundTo50(Sheets(sheetName).Range("M4")) .Chart.Axes(xlCategory).Ma 阅读全文
posted @ 2020-06-07 20:13 emanlee 阅读(1034) 评论(0) 推荐(0)
Excel VBA Convert Text String to Number
摘要： Convert String to IntegerMsgBox CInt("7.55")MsgBox CLng("13.5")Debug.Print "13.5" + "13.5"Sub Using_Variables() Dim valueOne As String valueOne = 5 Ms 阅读全文
posted @ 2020-06-07 17:44 emanlee 阅读(827) 评论(0) 推荐(0)