Edgar,

Edgar wrote:
I am using a UserForm to introduce data in an excel spreadsheet. I
grouped some TextBox into Frames in order to help the user to
identify the data required. Most of this data is numeric. I been
trying to use the exit event in order to validate the format of the
data introduce, but when the textbox is in a frame, the event seems
not to be recognize. Is there a way that allows to make the
validation without having to eliminate the frame?

I would suggest using the BeforeUpdate event to handle this. It will only
fire when the data has changed, and it should fire regardless of the parent
container (I just verified that it does work with Frame objects).

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]