Hi,
Why do I get a type mismatch error when this works:
but this doesnt:
Please Login or Register to view this content.
That is, the form initializes the values ok, but then when I add the code to calculate I get the type mismatch?Please Login or Register to view this content.
Any thoughts?
Thanks!
Hello umbata,
My best guess is the UserForm is not displayed as non-modal. When a window is modal, the owner of the window is prevented from receiving input until the modal window is dismissed.
You can change the modal property of the UserForm by setting the ShowModalproperty to False in the UserForm_Initialize() event.
If this does not fix your problem then you should post a copy of your workbook for review.Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
I am not able to reproduce the error. I am not sure how this could produce a type mismatch since a label caption value is a string and Format returns a string. There could be something funny going on in the call to Format. To isolate it, insert these lines of code and see if the error occurs on a Debug.Print line:
If not then the issue occurs during the assignment, and the results of the Debug.Print (CTRL-g to open the Immediate Window) might show you what is wrong.Please Login or Register to view this content.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
You would get that error if L11 contained an error value at the time the code runs.
Everyone who confuses correlation and causation ends up dead.
Romperstomper... you got it! My oversight. Thanks so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks