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, |
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 |