Please tell me how I can create textbox control array in excel macro.There is no property named index in excel macro.Please suggest alternative methods if possible.Thanks

To make an array of textboxes:
Useful for putting something in the boxes; not so good for getting stuff out.
I take care to name all the boxes I want in the array with the same prefix: eg tBox1, tBox2 etc.: and make sure no other control is prefixed the same.
then :
dim bx as object, i as integer
dim box(10) as object
for each bx in controls
   if left(bx.name,1)="t" then
      i=i+1
      set box(i)=bx
   end if
next

This should start you off!

Selbybrock