Integer only textbox?

  • Thread starter Thread starter Robert.Cordani
  • Start date Start date
R

Robert.Cordani

Can I set a textbox (on a form) to accept only integer values? If so
how?
TIA
 
Create an _AfterUpdate() routine for your text box and then check if
its an integer in your code.
 
Okay, I was afraid it wouldn't be as simple as a property value.

Thank you.
 
If the tool must use a userform then you are stuck with setting up
events for it, but if you had the input in a cell on a worksheet then
you could use simple Data Validation and set it to only whole
numbers.... just some thoughts
 
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

PowerPoint Shuffle (swap) objects on PPT slides with the same name only 0
Please HLEP: whats wrong with my code!? Adding textbox as runtime 3
Textbox and SpinControl - Class 8
QueryClose event of a form triggering Exit event of a textbox on that form 1
Set object with a function 3
Validate userform textbox entry with Sheet range. 2
need help on excel vba please :ActiveWorkbook.FollowHyperlink Address:="TextBox1.Text" 5
Textbox value 2

Back
Top