This is not a site but, find the used book:

Excel 2000 programming in 21 days.

It is no longer in print although you can buy a weird online version.

It steps you trough things and actually builds programs. After you have
digested this one the Walkenbach books are excellent for resource and lookup.

My own opinion of course.

"Ams" wrote:

any site which can teach VBA macro

Like what is the meaning of sub,dim,() etc in VBA