技術(shù) 點
- 技術(shù)
- 點
- V幣
- 點
- 積分
- 486
|
本人在給大家介紹一個簡單的錄入程序,對簡單卻繁鎖的數(shù)據(jù)輸入較有效,
如有不明白,或其他想與本人討論的請加QQ: 648715289
先建立一個窗體USERFORM1,添加三個文本框TEXTBOX1,TEXTBOX2,TEXTBOX3,再添加一個標(biāo)榜LABEL1
TEXTBOX1 用來輸貨號,編號,等等,輸入時只要輸入有代表性的幾位就可以了,如輸POLO-20315,可只輸入20315,如果包含20315的只有這個則馬上可以自動找出并輸入表格<如有POLO-20308,POLO-20309,POLO-20310,POLO-20312,POLO20313,POLO-20315....時)
TEXTBOX2 用來輸數(shù)據(jù),數(shù)量,重量,價格等
TEXTBOX3 用來輸貨號或編號特定不變的符號或文字<輸入后不自動變更>,沒有則不輸,
Dim CH1 As Range
Dim CH2 As Range
Dim DD1
Dim DD2
Private Sub TextBox1_Change()
TextBox3.Enabled = True
For Each CH1 In Sheets(1).Range("A1:A5000")
If CH1.Text Like "*" & TextBox1.Text & "*" Then
Label1.Caption = CH1.Text
DD1 = CH1.Row
GoTo LINE11
Else
End If
Next
LINE11:
End Sub
Private Sub TextBox1_Enter()
If TextBox3.Text = "" Then
TextBox1.EnterFieldBehavior = 0
Else
TextBox1.EnterFieldBehavior = 1
End If
If TextBox2.Text = "" Then
Else
For Each CH2 In Sheets(2).Range("A2:A5000")
If CH2.Text = "" Then
CH2.Value = Label1.Caption
Sheets(2).Cells(CH2.Row, 2).Value = TextBox2.Text
TextBox1.Text = TextBox3.Text
TextBox2.Text = ""
GoTo LINE1
Else
End If
Next
LINE1:
End If
End Sub
Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
Select Case KeyCode
Case 38 '按上光標(biāo)鍵清楚TEXTBOX1的內(nèi)容
TextBox1.Text = ""
Case 39 '右光標(biāo)鍵 繼續(xù)查找
For DD2 = DD1 + 1 To 5000
If Sheets(1).Cells(DD2, 1).Text Like "*" & TextBox1.Text & "*" Then
Label1.Caption = Sheets(1).Cells(DD2, 1).Text
DD1 = DD2
GoTo LINE2
Else
End If
Next
LINE2:
Case 37 '按左光標(biāo)鍵后的程序
End Select
End Sub
Private Sub TextBox2_Enter()
TextBox3.Enabled = False
End Sub
|
|