A simple yet efficient method to calculate the square root of a number is variously called the

divide$-$ and$-$average method. To find the square root of the number a:

Begin with an initial estimate $x.$

Divide the number by the estimate $($i$.$e$.,\frac{a}{x}),$ to get a new estimate

Average the original estimate and the new estimate $($i$.$e$.,\frac{x+\frac{a}{x}}{2}$ to get a new estimate

Return to step $2.$

Use this method to calculate the square root of a number. The value of the initial estimate $x$

must be greater than zero. Please use Do While Loop in the VBA program.