ID a position on str for a set of chars which mean certain labels appear in diff positions

[Michael Island]

In a ComboBox on a UserForm I use the following:

Please Login or Register  to view this content.

This populates the TextBox81 Fine. A Command Button later uses it to do this:

Please Login or Register  to view this content.

Then in the ComboBox code it does this:

Please Login or Register  to view this content.

It has 6 other If statements so it could produce this 28 character string:

e.g.

TextBox72.Value = "aNOxbYEScYESdYESeYESfYESgYES"

Then a particular piece of code (there are 6 more pieces) Counts how many CommandButtons are Enabled = False

Please Login or Register  to view this content.

Then much further down the ComboBox code I have this:

Please Login or Register  to view this content.

And it is not populating TextBox76 or editing the label (so it appears in the correct position in a Frame). Can you see where this goes wrong?

[alansidman]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[Michael Island]

Done, now can you help me please.

[sintek]

And it is not populating TextBox76 or editing the label (so it appears in the correct position in a Frame). Can you see where this goes wrong?

See yellow top banner

[Michael Island]

Hi sintech the code shows what is happening. If I include the worksheet with the hundreds of lines of VB code for the objects in this userform it will take months or weeks to go through it. Do you really need the Excel attached?

[sintek]

It has 6 other If statements so it could produce this 28 character string:

Then a particular piece of code (there are 6 more pieces)

And it is not populating TextBox76 or editing the label

Please Login or Register  to view this content.

So...Somewhere in this haystack of code of which half is not shown your criteria is not being met...Therefore it is bypassing this...

Please Login or Register  to view this content.

[Michael Island]

I have created a form as a UserForm and made it that the CommandButtons next to the TextBoxes become Enabled = True if the TextBox contents match a set of rules or the CommandButtons next to the TextBoxes become Enabled = False if the TextBox contents do not match a set of rules. On clicking this ComboBox it creates a string telling me what CommandButtons are Enabled = False (e.g. "aNOxbYEScYESdYESeYESfYESgYES") which is put in TextBox72. Then the code in ComboBox counts how many fields need to be fixed (in this case 1) and puts that in TextBox77. This tells me the size of the Frame required to display 1 'field row to fix' Label. The last bit of code tells me which fields, in order, need to be fixed by making the relevant Label visible and positioned correctly in a Frame and populating TextBox76 with only the negative code e.g. "aNOx". I will later use it for another purpose. If you want I can show you the code in the ComboBox?

[mjr veverka]

... not populating TextBox76 ... where this goes wrong?

Value in "TextBox81" <> 9 and in "TextBox77" <> 1, because the text fields contain text and not numeric values, "9" <> 9 and "1" <> 1.


Ps:

Topic title is highly unclear - change title

[Michael Island]

Hi I changed 'TextBox81.Value = 9' TO 'TextBox81.Value = "9" ' and 'TextBox77.Value = 1' TO 'TextBox77.Value = "1" ' and all worked fine so I'll set the Thread to 'SOLVED' and ADD to your reputation.

[mjr veverka]

Ok, nice ... : )
... but when it comes to identifying which of the buttons is active / inactive, you should do it using variables, then you have greater possibilities of operating on data, why refer to the text fields of the form every time ?

[Michael Island]

Noted. Use Variables to avoid this issue on small number sets. OK