Ambiguous Dates Crashing VBA User Forms
Hello,
I'm currently using a User form in a project Portfolio spreadsheet, and i'm having issues with dates (Communial groan) I have a field with the below logic applied to it: Code:
Private Sub Requested_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean) If a place a break point in the code at any point, it makes no difference. The code doesn't even it get called before the freeze, it seems. the only way to get out of this is killing the excel process in task manager. killing the program itself doesn't work, as it's still expecting data in the user form. i've tried building test cases, using the same data, but NOT in a user form, and i think it's an 'overflow' error message, but that doesn't help me. Somebody suggested changing the 'CDate' to 'Cdbl' but as i suspected, this just caused a mismatch error. Anyone had the same issue, and managed to work around it? |
All times are GMT +1. The time now is 05:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com