Using VBA to define input

[kevinonearth]

Hi,

I'm a VBA newbie.

I'm creating a form which includes % values and currency values

How do I insure that the user will only enter numeric values in each of these fields?

1st field must always be a %

2nd field must always be a currency amount


Thanks

Kevin

 

[kevinonearth]

Anyone?

 

[DaveTurton]

I don't think you can force currency or percentage however...


You could write vba code that triggers on change of the text box which checks if the entry is numeric and if not displays a warning message then clears the text box.


Then once the entry is numeric you can format the numeric value within your macro to whatever value you want.

 

[DaveTurton]

Something like this

[pre]

Private Sub TextBox1_Change()
If Not IsNumeric(Me.TextBox1.Value) Then
MsgBox "your message here"
Exit Sub

End If
End Sub

[/pre]