如何让vba用户窗体的文本框内自动显示出系统时间

VBA中窗体出现时触发事件，使用UserForm_Initialize()，类似VB中的Form_load()

VBA中的文本框是Textbox，而VB中的是text

日期都可以用Date函数来获得，默认是YYYY/M/D格式，如果一定要显示固定格式，可以format函数，例如Formt(Date,"yyyy-m-d")

故下面代码可实现题目中的要求——（假设日期框是textbox1）

Private Sub UserForm_Initialize()

TextBox1Text = Formt(Date,"yyyy-m-d")

End Sub

可以禁止修改系统时间即可，代码如下，源码可以发给你，你的邮箱是？窗体form1(需要一个timer控件，interval=1000):

窗体代码Private Sub Form_Load()

Timer1_Timer

RegisterWindow Mehwnd '为窗口设置子类

End SubPrivate Sub Form_Unload(Cancel As Integer)

unRegisterWindow Mehwnd '取消窗口的子类

End SubPrivate Sub Timer1_Timer()

OldTime = Now

End Sub'模块modle1:Option Explicit

Public Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long

Public Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, lParam As Any) As Long

Public Declare Function SetWindowLong Lib "user32" Alias "SetWindowLongA" (ByVal hwnd As Long, ByVal nIndex As Long, ByVal dwNewLong As Long) As Long

Public Declare Function CallWindowProc Lib "user32" Alias "CallWindowProcA" (ByVal lpPrevWndFunc As Long, ByVal hwnd As Long, ByVal msg As Long, ByVal wParam As Long, ByVal lParam As Long) As Long

Public Declare Function RegisterWindowMessage Lib "user32" Alias "RegisterWindowMessageA" (ByVal lpString As String) As Long

Public OldTime As String

Public ChangeFlag As Boolean

Public Const WM_TIMECHANGE As Long = &H1E '当系统的时间变化时发送此消息给所有顶级窗口

Public oldproc As Long

Private Type SYSTEMTIME

wYear As Integer

wMonth As Integer

wDayOfWeek As Integer

wDay As Integer

wHour As Integer

wMinute As Integer

wSecond As Integer

wMilliseconds As Integer

End Type

Private Declare Function SetLocalTime Lib "kernel32" (lpSystemTime As SYSTEMTIME) As LongPublic Function RegisterWindow(hwnd As Long) As Long

If hwnd <> 0 Then

oldproc = SetWindowLong(hwnd, -4, AddressOf WinProc)

End If

End Function

Public Function unRegisterWindow(hwnd As Long) As LongIf hwnd <> 0 Then

SetWindowLong hwnd, -4, oldproc

End IfEnd Function

Public Function WinProc(ByVal hwnd As Long, ByVal msg As Long, ByVal lpara As Long, ByVal wpara As Long) As LongDim i, myttIf msg = WM_TIMECHANGE And ChangeFlag = False Then '系统时间被修改了而且不是本程序修改的ChangeFlag = True '本程序要修改系统时间Call SetToOldTime '修改系统时间Exit FunctionEnd If

ChangeFlag = FalseWinProc = CallWindowProc(oldproc, hwnd, msg, lpara, wpara)

End Function

Public Function SetToOldTime() As String '将时间恢复到设置前的状态

Dim tmp As String

tmp = OldTime '从保存的时间中取出修改前的系统时间

Dim lpSystemTime As SYSTEMTIME

lpSystemTimewYear = Year(tmp) '取出年份

lpSystemTimewMonth = Month(tmp) '取出月份

lpSystemTimewDayOfWeek = -1

lpSystemTimewDay = Day(tmp) '取出日

lpSystemTimewHour = Hour(tmp) '取出小时

lpSystemTimewMinute = Minute(tmp) '取出分钟

lpSystemTimewSecond = Second(tmp) '取出秒

lpSystemTimewMilliseconds = 0

'set the new time

SetLocalTime lpSystemTimeEnd Function

Sub 当前日期()

Dim idate As Date

idate = Date

ActiveSheetRange("A1")Value = idate

End Sub

Sub abc()

Dim a, b, c As String '定义变量

a = Date '当前年月日

b = Time '当前时间

c = Now '当前年月日 和 时间

MsgBox a & b & c '显示 a ，b ，c

End Sub

Private Sub UserForm_Activate()

TextBox1Text = Format(Now, "yyyy年m月d日 hh:mm:ss AMPM")

End Sub

在窗体代码中输入上面代码就可以了，注意我这里的TextBox1Text你要改成你时间对应的文本框名称。

以上就是关于如何让vba用户窗体的文本框内自动显示出系统时间全部的内容，包括:如何让vba用户窗体的文本框内自动显示出系统时间、VB获取网络时间、用VBA编程显示当前日期等相关内容解答，如果想了解更多相关内容，可以关注我们，你们的支持是我们更新的动力！