Hi,
I made a program in Private Sub Worksheet_SelectionChange(ByVal Target As Range) event, so it will run some code everytime i select a cell.
The problem is, I get a lagg (ie, the excel sheet "flashes") everytime i click on a cell.
I am 100% sure the problem is caused by application.screenupdating, since if I remove that line, I don;t lagg; I get instant response
Any help would be appciated
Please Login or Register to view this content.
Thanks
Last edited by adds007; 08-20-2010 at 12:56 PM.
What are you doing in the code you omitted?
Entia non sunt multiplicanda sine necessitate
I have 2 main codes in the event.
first one, I can;t disclose cuz of company confidentiality issues. However, the problems still persists after commenting out this part.
Second one, adds checkmarks
The weird thing is, sometimes the problem disappears, and I see instant response.Please Login or Register to view this content.
When the problem is there tho, it;s annoying
Do you have code in the worksheet change event?
Do you have code that does Select?
Yes, I do have worksheet change event (not sure how it would be affect, just because of cliking)
In worksheet selectionchange event, i do have some select code, but it starts off by enableevents=false and end with enableevents=true
I hope those are the answers you were looking for
Selects and Activates defeat ScreenUpdating. I reckon the run-time figures if you put them there, you meant to.
EDIT: I should add, they are almost never necessary.
Last edited by shg; 08-19-2010 at 03:49 PM.
i am sorry
I am not sure what you mean by run-time figues and how to do it
Post the code where you do Select
I am gonna go home soon, sorry if i don;t reply fast enoughPlease Login or Register to view this content.
I will definetly reply tomorrow, if not today
So delete all the rows that do Select.
Why do you Select those Ranges? You don't use them.
What is this supposed to do?
It should be something likePlease Login or Register to view this content.
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
When you set screenupdating to true you force a refresh, so it's not really that surprising that you get the effect you describe.
Everyone who confuses correlation and causation ends up dead.
Sorry for late reply, back to work
@Shg, i commented out all selects in my event, the problem still persists
@royUK,
I need that code if i want to add a checkmark to the selected cell, if it's valid
I copied this code from this forum i think. It seems to do what I want.
I am pretty sure that's not the problem tho
@romperstomper, I removed the last line Application.ScreenUpdating = True, but the problem still persists
Thank you all for speedy responses
It will be set back to true when the sub exits anyway. The point is to only set it to false if you actually need to. Otherwise you are forcing a redraw for no reason.
I need have the screenupdating=false, otherwise it takes too long for checkmarks to appear for multiple selected cells
But you turn it off whether or not you do anything.
I think you would get a better answer if you posted the complete code probably by attaching a workbook & saying what you want to do.
ok so i did what you told me, and only added the line where i needed it
The good thing is, it doesn;t flash anymore for any columns except the checkmark column (column B)Please Login or Register to view this content.
The bad thing is, it still flashes for like 0.5s when i place a checkmark or select multiple rows in column B
This is probably very bad example, but I can;t post the original cuz of confidentiality issues
So i built a test workbook, which doesn;t really lagg (i don;t know why)
I hope this is helpful
Is this what you want
Please Login or Register to view this content.
wow, that actually removed the flashes
YOU ARE AMAZING!!!!
just 1 small thing, if you don;t mind
i can;t deselect a range of cells (checkmarks don;t disappear when i select multiple cells)
I really appreciate it tho
I am not sure why making this change caused the flashes to go away, I am really happy now tho
Thanks again
Last edited by adds007; 08-20-2010 at 12:57 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks