设置系统时间.

该博客展示了通过VBA代码实现系统时间的获取与设置功能。代码中声明了获取和设置系统时间的函数,定义了系统时间类型,在按钮点击事件中可设置系统时间,在窗体加载时获取系统时间并显示,涉及整数类型变量的使用。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

time

Option Explicit

Private Declare Sub GetSystemTime Lib "kernel32" (lpSystemTime As SYSTEMTIME)

Private Declare Function SetSystemTime Lib "kernel32" (lpSystemTime As SYSTEMTIME) 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
Dim time As SYSTEMTIME


Private Sub Command1_Click()
Dim hour As Integer
hour = txttime(3) - 8   'Beijing Time

With time
    .wYear = txttime(0).Text
    .wMonth = txttime(1).Text
    .wDay = txttime(2).Text
    .wHour = IIf(hour > 0, hour, hour + 24)     'set universal time
    .wMinute = txttime(4).Text
    .wSecond = txttime(5).Text
End With
SetSystemTime time
   
End Sub

Private Sub Form_Load()
    GetSystemTime time
    With time
        txttime(0).Text = .wYear
        txttime(1).Text = .wMonth
        txttime(2).Text = .wDay
        txttime(3).Text = .wHour + 8    'Beijing Time
        txttime(4).Text = .wMinute
        txttime(5).Text = .wSecond
    End With
   
End Sub

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值