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?

Thanks

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]