Ik heb een Userform ingesteld om bestellingen in op te nemen.
Nu wil ik sommige velden, zoals het Invoicenummer alleen numeriek laten invullen. Ik heb al enkele dingen geprobeerd, maar zonder succes.
Kan iemand mij vertellen hoe ik dit voor elkaar krijg?
Mijn code ziet er als volgt uit:
Private Sub cmdInvoeren_Click()
ActiveWorkbook.Sheets("Sheet1").Activate
Range("C9").Select
ActiveCell.Value = txtFreight.Value
ActiveCell.Offset(-5, -2) = cboTransporter.Value
ActiveCell.Offset(-4, 0) = txtInvoice.Value
ActiveCell.Offset(-2, 0) = txtLocalInvoice.Value
ActiveCell.Offset(3, 0) = txtWarehouseHandling.Value
ActiveCell.Offset(4, 0) = txtInlandTransport.Value
ActiveCell.Offset(5, 0) = txtClearing.Value
ActiveCell.Offset(6, 0) = txtAdminCharges.Value
ActiveCell.Offset(6, 6) = txtABBonfreight.Value
ActiveCell.Offset(7, 6) = txtABBonservices.Value
ActiveCell.Offset(-4, 5) = txtWisselkoers.Value
ActiveCell.Offset(0, 5) = txtVolume.Value
ActiveCell.Offset(7, 0) = txtSpecialTariff.Value
ActiveCell.Offset(-3, 0) = Now()
ActiveCell.Offset(8, 0) = Environ("USERNAME")
Range("C9").Select
'verwijder gegevens
Me.cboTransporter.Value = ""
Me.txtInvoice.Value = ""
Me.txtLocalInvoice = ""
Me.txtFreight.Value = ""
Me.cboTransporter.Value = ""
Me.txtWarehouseHandling.Value = ""
Me.txtInlandTransport.Value = ""
Me.txtClearing.Value = ""
Me.txtAdminCharges.Value = ""
Me.txtABBonfreight.Value = ""
Me.txtABBonservices.Value = ""
Me.txtWisselkoers.Value = ""
Me.txtVolume.Value = ""
Me.txtSpecialTariff.Value = ""
End Sub
Private Sub UserForm_Initialize()
cboTransporter.RowSource = "Data!A:A"
End Sub
Private Sub cmdSluiten_Click()
Unload Me
End Sub
Bij voorbaat dank!
Nu wil ik sommige velden, zoals het Invoicenummer alleen numeriek laten invullen. Ik heb al enkele dingen geprobeerd, maar zonder succes.
Kan iemand mij vertellen hoe ik dit voor elkaar krijg?
Mijn code ziet er als volgt uit:
Private Sub cmdInvoeren_Click()
ActiveWorkbook.Sheets("Sheet1").Activate
Range("C9").Select
ActiveCell.Value = txtFreight.Value
ActiveCell.Offset(-5, -2) = cboTransporter.Value
ActiveCell.Offset(-4, 0) = txtInvoice.Value
ActiveCell.Offset(-2, 0) = txtLocalInvoice.Value
ActiveCell.Offset(3, 0) = txtWarehouseHandling.Value
ActiveCell.Offset(4, 0) = txtInlandTransport.Value
ActiveCell.Offset(5, 0) = txtClearing.Value
ActiveCell.Offset(6, 0) = txtAdminCharges.Value
ActiveCell.Offset(6, 6) = txtABBonfreight.Value
ActiveCell.Offset(7, 6) = txtABBonservices.Value
ActiveCell.Offset(-4, 5) = txtWisselkoers.Value
ActiveCell.Offset(0, 5) = txtVolume.Value
ActiveCell.Offset(7, 0) = txtSpecialTariff.Value
ActiveCell.Offset(-3, 0) = Now()
ActiveCell.Offset(8, 0) = Environ("USERNAME")
Range("C9").Select
'verwijder gegevens
Me.cboTransporter.Value = ""
Me.txtInvoice.Value = ""
Me.txtLocalInvoice = ""
Me.txtFreight.Value = ""
Me.cboTransporter.Value = ""
Me.txtWarehouseHandling.Value = ""
Me.txtInlandTransport.Value = ""
Me.txtClearing.Value = ""
Me.txtAdminCharges.Value = ""
Me.txtABBonfreight.Value = ""
Me.txtABBonservices.Value = ""
Me.txtWisselkoers.Value = ""
Me.txtVolume.Value = ""
Me.txtSpecialTariff.Value = ""
End Sub
Private Sub UserForm_Initialize()
cboTransporter.RowSource = "Data!A:A"
End Sub
Private Sub cmdSluiten_Click()
Unload Me
End Sub
Bij voorbaat dank!