Highlight textbox if date <=60 days referencing an array as textbox numbers

A dblclick event loads a userforms textboxes from 1 to 46

textboxes 27,29,31,33,37,39 and 41 are expiry dates, I am trying to highlight these if due with 60 days

I have tried various forms of this but just cant seem to be able to reference the array value only
When I try using "For j =" a message box appears saying Expected "To"

Please Login or Register  to view this content.

Any pointers appreciated

the code to load the userform is

Please Login or Register  to view this content.

Assuming the code runs in a userform.

Please Login or Register  to view this content.

To loop through the controls.

Please Login or Register  to view this content.

Using a phone so not sure which is the problem for you, but that's how to loop through controls and 1 way to loop through an array.

To give you an idea how it works.

Please Login or Register  to view this content.

Hi Cytop
Will not accept

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Its the referencing of the array that seems to be the issue

thanks Bakerman, Ill have a look

Your code was handy to understand the array principal so got as far as here

Please Login or Register  to view this content.

The error now is on the reading of the actual textbox value

Or in full.

Please Login or Register  to view this content.

Thanks Bakerman I learnt a valuable usable method of referencing an array

Code still highlights the

Please Login or Register  to view this content.

Im guessing the code loading the form is loading the data as text rather than a date value
All Textbox dates are displayed in "dd mmm yyyy" if that makes a difference (No I checked and loaded in "dd mm yyyy" format but still same)

I ran without that line and textboxes are highlighted so it is the DateValue is problem. Ill look it up.

@ cytop

Missed that one.

Please Login or Register  to view this content.

You also need to test the textbox contents can be coerced to a date - and a blank textbox will raise an error. It also needs a check if the procedure runs again to remove the colouring from any textboxes which may have had invalid dates earlier, but now have valid dates...

Sorry to try and take this a different direction, but I think the following is easier to follow the logic.

Please Login or Register  to view this content.

@ cytop

Perfect, thankyou...can use that in a few other areas

@ Bakerman

Many thanks

I will mark as solved

Please Login or Register  to view this content.

You're welcome and thanks for rep+.