Looping variable or arrays for boolean?

[calvinle]

Hi,

I am not familiar with array, but i am looking for a way to declare variable thru my looping.

Let's say example in Userform, I have 5 textbox.

Textbox1
Textbox2
Textbox3
Textbox4
Textbox5

And I want to do such as:

Please Login or Register  to view this content.

I want to identify via looping the textbox and associate the boolean variable if the textbox contains data.

Any help?

[MarvinP]

Hi Calvin,

Your code worries me. If you declare those Textboxes as Boolean I'm not sure you can do a text function of Len() on them.

Read:
https://msdn.microsoft.com/en-us/library/ae382yt8.aspx

I think of a Boolean data type as being a 0 or 1. Both have Length of 1. BUT I'm not sure you can treat them like a string of characters. Normally when you Dim a String it saves a spot in memory for that string and the first character or two are the length of the string. In Boolean you don't have that construct. Just a On/Off or Yes/No or True/False, no length.

Have you tried to Dim your TextBoxes as Text and see what happens then?

[calvinle]

Hi,

Indid not declare those textbox ads boolean but I want to associate a boolean variable if the lenght is over 0 for each textbox using a loop function.

Thanks.

[MarvinP]

In the code you list above the DIM statement and "declare them" mean the same thing.

Try your code again after using

Please Login or Register  to view this content.

[calvinle]

If I declare blntext to String, how can it be in boolean?

[Norie]

Try this.

Please Login or Register  to view this content.

[mikerickson]

Perhaps

Please Login or Register  to view this content.