Verify the format of the content of a textbox included in a frame
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 |
Verify the format of the content of a textbox included in a frame
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] |
All times are GMT +1. The time now is 02:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com