Excel VBA Topic 3.3 - Built-in Functions in VBA

preview_player
Показать описание
Рекомендации по теме
Комментарии
Автор

Sqr is a VBA function, while Sqrt is an Excel worksheet function. I don't know why they did not make them the same. Most languages use sqrt.

CPPMechEngTutorials
Автор

Hello,

I was confused and thought when sqr was mentioned in the video, that what was being spoken about was a function entered into a worksheet, but I see now that what is being spoken of is a function being entered via VBA. Sqr is quite valid in VBA, my mistake and misunderstanding.

Thanks,
David

davidlanman
Автор

I am using Excel 7 and I get that the square root is SQRT().
Thanks,
David

davidlanman