Numerical entry for list boxes on a user form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a user form with 3 text boxes that inputs information onto a worksheet.

What code do I need to make sure the textboxes only accept numerical entry.
ie I only want a user to enter numbers, not letters

....and would I put the code inbetween this section: -

Private Sub TextBox2_Change()

End Sub

TIA
 
See reply from Nicke to your question in .programming, and don't multipost.
 
Sorry bout that. Ddin't mean to multipost. I got an error with the first post
and tried again.

Antway, that code didn't work for me but I'll write to Nicke in programming

Thanks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to run excel vba code when cell value changes from empty to entered value. 1
data input format 1
Excel Worksheet_BeforeDelete code not working as expected. 1
Create a yes no message on a command button on click 0
error in userform 6
Userform and variables 1
Validation list in data entry form 4
clock on user form 6

Back
Top