For the first question:
1. Once in Microsoft Visual Basic Editor go to View then click Tab Order. You can tell Visual Basic which textboxes would be highlighted first.
For the second question:
If Not IsNumeric(TextBox1.Value) Then 'numeric values
MsgBox("Please enter a numeric value.")
End If
If Not IsDate(TextBox1.Value) Then 'dates
MsgBox("Please enter a valid date.")
End If
I'm trying to create Forms for our employees at the office to fill out using Excel. Is this even the program to use when creating forms?
Anyway, I have several questions I hope some of you can help me with.
1) I have inserted a series of TextBoxes for my employees to fill out - how do I determine the order of tabs? 1, 2, 3 as the press the tab key when filling the forms.
2) How do I define to text boxes to take only whole numbers or only dates?
Thanks

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic