|
Public YGBH As String '定义用于记录“员工编号”的变量
Public YGXM As String '定义用于记录“员工姓名”的变量
Public YGXB As String '定义用于记录“员工性别”的变量
Public CSNY As String '定义用于记录“出生年月”的变量
Public YGXL As String '定义用于记录“员工学历”的变量
Public GZSJ As String '定义用于记录“工作时间”的变量
Public YGZW As String '定义用于记录“员工职务”的变量
Sub canel() '用于对全局变量进行初始化
YGBH = " "
YGXM = " "
YGXB = " "
CSNY = " "
YGXL = " "
GZSJ = " "
YGZW = " "
End Sub
Sub note() '用于完成录入功能
Dim tempmsgbox As VbMsgBoxResult
Dim count As Integer
if UserForm1.TextBox1.Text=" " or
UserForm1.textbox2.text=" " or
userform1.textbox3.text=" " or
UserForm1.TextBox4.Text = " " or
ygxb=" " or
ygxl=" " or
YGZW = " " then tempmsgbox=msgbox("请输入完整的信息!",vbokonly & vbinformation,"系统提示")
End
End If
End Sub
If UserForm1.TextBox1.Text = " " Or _
UserForm1.textbox2.Text = " " Or _
UserForm1.textbox3.Text = " " Or _
UserForm1.TextBox4.Text = " " Or _
ygxb = " " Or _
ygxl = " " Or _
YGZW = " " Then tempmsgbox = MsgBox("请输入完整的信息!", vbOKOnly & vbInformation, "系统提示")
End
End If
|
|