Knowing the time it takes for code to run

[yinkajewole]

How do you i know the particular line of code that consumes time to run?

 

[Michael M]

You could comment out all the lines that aren't relevent !
OR
You could apply a timer before and after the line you think is causing issues.
What seems to be the issue ?
How long is your code taking to run ??
CAn you share the code....it may be soething else slowing your code down, if that is the problem

 

[yinkajewole]

Actually, there are some bitmaps in some archives. Using VBA, I use 7zip to extract the bitmaps and set them to a Picture box one after the other on a userform.
Well, I think using an external program (7zip) to extract the bitmaps must have been the cause of the little slow down.
However, I'm think that using a DLL to extract the bitmaps and possibly using binary mode can make it faster. Unfortunately, I don't have the idea.
Do you have any idea on how to go about this?