thomaspatton
03-07-2008, 04:33 AM
Almost done with my new workbook and I ran into a problem out of nowhere yesterday. The issue I'm having is with Worksheets("Class Information").
Yesterday, after doing alot of the writing on other pages, I came back to test some things out and none of the custom format settings were working. In fact, in column B, the first time I would try typing something, it would replace it with "Target" and afterwards would do nothing to the text. Was going to post here about that, but it miraculously fixed itself(?) overnight and now works as intended.
Now, still with Class Information, it's becomes horribly laggy on Change to any cell that reformats the input. When I first wrote this page, it worked beautifully. It seems the more I add to the workbook VBA, though, the more buggy it gets. So, any cell that is autofromatted takes about 2-3 to update, meaning I can't type in another cell until it's done. Normal cells work fine.
Also, a newer issue but probably related to the same area because the runtime hilights the App.WkSht.Proper(Target) line on Class Info. When I run 'Sort Index' to bring up 'ufClassInformationSort' that works fine. I _Click() any of the 'cmdAPCSeatSort', 'cmdEPCSeatSort', or 'cmdHazSeatSort' and I get 'Runtime 13 : Type Mismatch' and the hilighted portion from above.(The one that XLD helped me with here (http://www.vbaexpress.com/forum/showthread.php?t=18084))
Neither of these problem happened when I first made the book. I made only one change to 'Class Information' since writing the code portion and all it was was adding a column between q:r. And yar, I updated my column references afterwards. Anyone mind checking it out and letting me know what I'm doing wrong here?
Yesterday, after doing alot of the writing on other pages, I came back to test some things out and none of the custom format settings were working. In fact, in column B, the first time I would try typing something, it would replace it with "Target" and afterwards would do nothing to the text. Was going to post here about that, but it miraculously fixed itself(?) overnight and now works as intended.
Now, still with Class Information, it's becomes horribly laggy on Change to any cell that reformats the input. When I first wrote this page, it worked beautifully. It seems the more I add to the workbook VBA, though, the more buggy it gets. So, any cell that is autofromatted takes about 2-3 to update, meaning I can't type in another cell until it's done. Normal cells work fine.
Also, a newer issue but probably related to the same area because the runtime hilights the App.WkSht.Proper(Target) line on Class Info. When I run 'Sort Index' to bring up 'ufClassInformationSort' that works fine. I _Click() any of the 'cmdAPCSeatSort', 'cmdEPCSeatSort', or 'cmdHazSeatSort' and I get 'Runtime 13 : Type Mismatch' and the hilighted portion from above.(The one that XLD helped me with here (http://www.vbaexpress.com/forum/showthread.php?t=18084))
Neither of these problem happened when I first made the book. I made only one change to 'Class Information' since writing the code portion and all it was was adding a column between q:r. And yar, I updated my column references afterwards. Anyone mind checking it out and letting me know what I'm doing wrong here?