Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
add comment in the loop
I have following code to add comment to my cells from MS Acess tbale
ActiveSheet.Cells(i, j + 1).AddComment MyDatabase.Fields(j - 1).Value It works and adds comment to my cell. The problem is when it is in the loop which does not add second row of comments. Application.Wait (Now + TimeValue("0:00:03")) I have to add the wait 3 seconds command in the loop and it adds second row of comments. Does it make sense that it needs 3 seconds to add one row of comments? It will be too long if I have a couple lines. Any ideas or work around for this? Your information is great appreciated, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
add comment in the loop
Hi,
How about adding Application.ScreenUpdating = false before the loop. And, set it to true once the loop is over. Does that work? Kalpesh |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
add comment in the loop
I had to add wait to fill the spreadsheet.
I tried to use screen updating, but it is the same, Thanks again for helping, "Kalpesh" wrote: Hi, How about adding Application.ScreenUpdating = false before the loop. And, set it to true once the loop is over. Does that work? Kalpesh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop to Filter, Name Sheets. If Blank, Exit Loop | Excel Programming | |||
How do I remove the red corner in excel comment and keep comment? | Excel Programming | |||
How can I edit a comment w/o first having to select Show Comment | Excel Discussion (Misc queries) | |||
Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
a comment plugin & copy paste directly from excel to comment ? fr. | Excel Worksheet Functions |