I am not familiar with this lens so I have to rely on a review to find the minimum focus distance. According DPR's review it is 11cm. The lens will not be able to focus on anything nearer than that no matter what mode is selected.
DPR review of the lens
http://www.dpreview.com/lensreviews/...p5-5p6_vr_n15/
Here is a link to DPR's review of the camera. Page 7 details the various modes and a bit about each one.
http://www.dpreview.com/reviews/nikond5000/default.asp
I hope that is of some help.
Don