Assigning Text Box Event through Class to required Text Box

[Naveed Raza]

Hi All,

I am need of suggestion/debug on below part of code, as i unable to understand why code is not assigning event.

Query is i have 1 list box in that list for some value we required textbox and based on that label and textbox will visible and the position of label and text box is not fixed and for the last value of denied reason list we have 3 text box respectively and i want to add keydown event to that textbox below is the code for that.

Click on EOP Notes tab --> Click on Denied reason and click on value from the list and for last 2 value we have text box and in that user will enter date, once user enter date the date format should be change to (dd-mmm-yyyy).

Please Login or Register  to view this content.

[Andy Pope]

you need to create a new instance of the object

Please Login or Register  to view this content.

Although that get you past your error it will not work as you expect. Because you have scoped the TextBoxes array within the routine once you exit objects will be released from memory, but the controls will still remain. You need to declare the array at the module level of the userform.

[Naveed Raza]

Hi Andy Pope,

i added that provided line in my code its pass the error,however the event not getting executed, could you please let me know how to over come with this. If possible could you please modify my code at required line.

thank you !

[Andy Pope]

I did. You need to move the declaration of the TextBoxes array out of the list_change routine and put it at the top of the code module.

[Naveed Raza]

yes. i made TextBoxes as universal and its working fine, but only for "Audit Closure (Member)" text boxes, however for Audit Closure (Provider) its not working.

i added OR at IF Condition to get event to both Provider and Member, however its getting only for Member.

Please Login or Register  to view this content.

or shall i add another Event in Class2. please suggest.

please see the screen shot.

[Andy Pope]

Well I assume you uncommented that section of your code and added the new set command as per previous sugeestion

[Naveed Raza]

Hi Andy Pope.

Thank you for your help its resolved.

i added 2 different event for Provider & Member in Class now its working fine.

Thank you !