Write If/And statement for userform textboxes that are only visible

[clemsoncooz]

I am trying to write an "if + and" statement that is like the following. (This is all for a userform)

Upon the user hitting the submit buttton:

Please Login or Register  to view this content.

it ths only visible textboxes that are blank I am having trouble with and dont know how to code.

Those textboxes that are named (and visible -which is dyanimic):

Please Login or Register  to view this content.

and tbxBuildingcount is just a value from a spin button.


I am just trying to error trap and make sure that the user has filled out every visible textbox and if they dont, then warn them that they do.
The reason for the checkbox is that is it is true, then they can proceed. But if false, and some blank textboxes, they get this warning.

Thanks in advance.

[tigeravatar]

clemsoncooz,

Give this a try:

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

You mention textboxes plural but your code only shows one TextBox(y). In which case why not just

Please Login or Register  to view this content.

[clemsoncooz]

You mention textboxes plural but your code only shows one TextBox(y). In which case why not just[...]

"Y" is a loop starting at 1 and ending at whichever the user choose tbxBuidlingcount to be by using a spin buttong. tbxbuilidngcount will be a number 1 to 10.


EDIT UPDATE: I posted this before thinking about your recommendation. Sorry. I thought you were saying that I only have one text box (opposite of plural). So I posted. But now after I re-read your post - I think this could work. Let me see.

[clemsoncooz]

I havent tried tigeravater's recommendation yet. Thats what I am working on now. Stay tunned.

[clemsoncooz]

Hi,

You mention textboxes plural but your code only shows one TextBox(y). In which case why not just

Please Login or Register  to view this content.

Okay - For me to do this I think - it requires a second question: How do I use variables from a another private procedure that is within the same module?

Because where I am writing this If statement is located within the SUBIT click event. And I define Y in another private procedure go a "GO button" Click event.

[clemsoncooz]

clemsoncooz,

Give this a try:

This took care of it tigeravatar (I justed needed to change one "OR" to an "AND")!!!

Thank you so much!