My problem is when I make UserForm that contain, textboxes and a
command button. The simulation is simple. There is two textbox as lower
value and higher value that used to enter a number which linked to
many cells that contain many linked formula on sheets.Where one textbox
show the result of the simulation.

And I run the operation on range of lower value and higher value, with
procedure For-Next. And some error will occure, on the operation if I
enter the lower value too small, or the higher value to big.

Is there any procedure to ignore the error message by VBA and turn it
with my MsgBox. And when I click OK on my MsgBox, the value that I have
entered in textbox is cleared so the macro still run and I can reenter
the textbox with a new value.