VBA: Check all text boxes within frame for integer

[FryGirl]

I have a UserForm with a number of textboxes all those textboxes are within a frame (frm1). As the user enters data into any one of these textboxes, how can I ensure a non-integer is not entered?

 

[Rick Rothstein]

The best answer and best approach depends on your answer to these questions...

How many TextBoxes are "a number of textboxes"... 3, 10, 50???

What naming system, if any, did you use for the names of these TextBoxes?

 

[FryGirl]

Well thanks Rick for your interest. There will be three Textboxes in a frame. I might as well make this naming convention easy.

txtPercentage1
txtPercentage2
txtPercentage3

 

[FryGirl]

Bump

 

[FryGirl]

Thanks all. I finally found what I need.

All Textboxes in a frame

Hi All Im trying to get a code that allow the user to proceed unless a all textboxes and comboboxs in a frame is filled first. if its not filled a msgbox pop saying "Please fill the Info above to proceed" thanks

www.mrexcel.com