http://www.vbex.ru/index.php?action=history&feed=atom&title=VBA%2FExcel%2FAccess%2FWord%2FLanguage_Basics%2FResume
VBA/Excel/Access/Word/Language Basics/Resume - История изменений
2026-04-06T03:05:04Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.vbex.ru/index.php?title=VBA/Excel/Access/Word/Language_Basics/Resume&diff=1182&oldid=prev
в 16:33, 26 мая 2010
2010-05-26T16:33:00Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 16:33, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://www.vbex.ru/index.php?title=VBA/Excel/Access/Word/Language_Basics/Resume&diff=1183&oldid=prev
Admin: 1 версия
2010-05-26T12:46:34Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Check the error number with Select Case statement==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="vb"><br />
<br />
Sub SelectionSqrt()<br />
Dim cell As range<br />
Dim ErrMsg As String<br />
If TypeName(Selection) <> "Range" Then Exit Sub<br />
On Error GoTo ErrorHandler<br />
For Each cell In Selection<br />
cell.value = Sqr(cell.value)<br />
Next cell<br />
Exit Sub<br />
ErrorHandler:<br />
Select Case Err<br />
Case 5 "Negative number<br />
Resume Next<br />
Case 13 "Type mismatch<br />
Resume Next<br />
Case 1004 "Locked cell, protected sheet<br />
MsgBox "The cell is locked. Try again."<br />
Exit Sub<br />
Case Else<br />
ErrMsg = Error(Err.number)<br />
MsgBox "ERROR: " & ErrMsg<br />
Exit Sub<br />
End Select<br />
End Sub<br />
</source><br />
<br />
<br />
<br />
<br />
==Uses a Resume statement after an error occurs:==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="vb"><br />
<br />
Sub EnterSquareRoot6()<br />
Dim Num As Variant<br />
Dim Msg As String<br />
Dim Ans As Integer<br />
TryAgain:<br />
On Error GoTo BadEntry<br />
Num = InputBox("Enter a value")<br />
If Num = "" Then Exit Sub<br />
ActiveCell.value = Sqr(Num)<br />
Exit Sub<br />
BadEntry:<br />
Msg = "An error occurred. Try again?"<br />
Ans = MsgBox(Msg, vbYesNo)<br />
If Ans = vbYes Then Resume TryAgain<br />
End Sub<br />
</source><br />
<br />
<br />
<br />
<br />
==using the On Error Resume Next statement==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="vb"><br />
<br />
Sub SelectionSqrt()<br />
Dim cell As range<br />
If TypeName(Selection) <> "Range" Then Exit Sub<br />
On Error Resume Next<br />
For Each cell In Selection<br />
cell.value = Sqr(cell.value)<br />
Next cell<br />
End Sub<br />
</source></div>
Admin