看到这个:http://www.excelpx.com/dispbbs.asp?BoardID=5&replyID=11657&id=18037&skin=0
Sub test3() Dim time1, time2 time1 = "2005-9-8" time2 = "2007-4-7" MsgBox "间隔" & Application.Evaluate("=Datedif(""" & time1 & """,""" & time2 & """,""y"")") & "年"End Sub
假如只是把常量直接带入到msgbox语句,请问怎样修改?谢谢!
使用道具 举报
谢谢阿木!
我试时,对常数,只打了1层引号或没打。没想到,原来要打2层呀。学习了。
什么情况下,需要打2层啊?
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-5-16 19:25 , Processed in 0.252432 second(s), 7 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.