numeric field form

  1. T

    allow phone numbers with spaces on a user form

    Hello all, I have a user form that have a phone and a fax field that i dont want letters entered. i have in my code If Not IsNumeric(Phone.Value) Then MsgBox "Phone number not valid" Exit Sub End If But dosnt allow number with spaces ideally the number format should...
  2. B

    make form field content selected upon opening form

    I show a form in Excel2007. I want a particular input field to appear selected upon entry. Is there a way to do this - apart from simulating keyboard entries TAB and SHIFT-TAB? Also, I would like to lock the input to be numeric. I do it today by checking the contents, but would have thought...

Some videos you may like

This Week's Hot Topics