format a TextBox on a userform

I am creating a userform in vba with textboxes. Input (from user) into the textbox is copied to a worksheet in the workbook.

I one text box users will need to type numbers and in another they will need to type letters.

Can the textbox be formatted so it will only allow a number?
Can the text box be formatted to only allow text?

I have attached the workbook.

Thanks,
Randy

What about the following?

Please Login or Register  to view this content.

You can use similar logic using IsText() for your second textbox.

Martin

I thought that was going to be easy, but it's anything but. The IsText function, doesn't work as it assumes that everything in the textbox is text; even numeric data.

There are probably heaps of better solutions and I'm sure (and hope) that someone will make a better suggestion, but here is my solution.

My logic is as follows:

1. Dimension a variable as numeric so it can't contain text.
2. Try to store the contents of the textbox in the numeric variable
3. If it can be stored, it is a number
4. If it can't be stored, then the error handling will kick in and the err.number will equal 13 not 0. i.e. it must have been text.

Please Login or Register  to view this content.

HTH
Martin

Actually, a simpler way - DOH! - would be to reverse the logic on the original and remove the "Not"

Please Login or Register  to view this content.

Glad to help
Martin