Passing Values Between Userform Events

[Bob1980]

Hi All,

My proficiency with VBA is increasing, thanks to everyone in this forum. I've been having a problem, and can't seem to find any answers online. I'm using a userform and utilizing the userform events. I created an array, and am trying to pass the values from the array between the events within the same userform. One event is creating the array, and the other event is deleting the last element within the array. Below is an example of the code.

Please Login or Register  to view this content.

Error 13, type mismatch occurred during the UBound function within the Find method. The VBA editor is showing that UBound(Array) = "Empty". How do I pass the array elements between events within the same userform, without using excel workbooks as the intermediary? I guess I'm just trying to get more sophisticated with my code, and become less dependent on worksheet values.

Thanks!
Bob1980

[Bob1980]

Another note:

I basically want to create an array, use a "Back" button feature to delete the last element of that array, delete any occurance of that last element within specified ranges within the worksheet, and add another array element after the previous element was deleted. I hope this makes sense.

[Norie]

Declare Array at the top of the userform module, outwith any sub.

Oh, and change the name - VBA's not going to like you using Array.

[Bob1980]

Thanks Norie, you're the best.