VBAスタンダード練習

順位 | 名前 | スコア | 称号 | 打鍵/秒 | 正誤率 | 時間(秒) | 打鍵数 | ミス | 問題 | 日付 |
---|---|---|---|---|---|---|---|---|---|---|
1 | ku | 5056 | B+ | 5.0 | 99.2% | 132.7 | 676 | 5 | 50 | 2025/01/13 |
2 | ku | 4970 | B | 4.9 | 100% | 136.0 | 676 | 0 | 50 | 2025/04/10 |
3 | あ | 3140 | E++ | 3.1 | 98.5% | 212.1 | 676 | 10 | 50 | 2025/04/17 |
4 | しげ | 1809 | F | 1.9 | 91.3% | 338.2 | 676 | 64 | 50 | 2025/02/24 |
関連タイピング
-
Excel VBA たぶんよく使う用語です
プレイ回数2370英字170打 -
プレイ回数690長文英字713打
-
コード&関連用語
プレイ回数1281英字357打 -
エクセル関数名をタイピングする。
プレイ回数821短文英字107打 -
練習しながらEXCEL関数を覚えよう
プレイ回数2306長文843打 -
officeTanaka.netでVBAの勉強
プレイ回数715長文60秒 -
コード集
プレイ回数840英字371打 -
プレイ回数611長文363打
問題文
(variant)
Variant
(lbound)
LBound
(redim preserve)
ReDim Preserve
(set a = nothing)
Set A = Nothing
(do until)
Do Until
(loop until)
Loop Until
(do while cells(i, 1) = ”xx”)
Do While Cells(i, 1) = "xx"
(loop while cells(i, 1) = ”xx”)
Loop While Cells(i, 1) = "xx"
(case is)
Case Is
(case else)
Case Else
(for each a in selection)
For Each A In Selection
(large)
Large
(small)
Small
(worksheetfunction)
WorksheetFunction
(if a is nothing then)
If A Is Nothing Then
(if not a is nothing then)
If Not A Is Nothing Then
(currentregion)
CurrentRegion
(phonetic.text)
Phonetic.Text
(subtotal)
Subtotal
(this workbook.path)
This Workbook.Path
(format(now, ”yyyymmdd”))
Format(Now, "yyyymmdd")
(lookat:=xlwhole)
LookAt:=xlWhole
(find(what:=...lookat:=...))
Find(What:=...LookAt:=...)
(lookat:=xlpart)
LookAt:=xlPart
(filecopy)
FileCopy
(cells(rows.count, 1).end(xlup).row)
Cells(Rows.Count, 1).End(xlUp).Row
(mkdir)
MkDir
(entirerow)
EntireRow
(entirecolumn)
EntireColumn
(resize(1, 3))
Resize(1, 3)
(offset(0, 1))
Offset(0, 1)
(autofilter field:=1)
AutoFilter Field:=1
(xlor)
xlOr
(xland)
xlAnd
(sort.sortfield.clear)
Sort.SortField.Clear
(sort.sortfield.add2)
Sort.SortField.Add2
(xlascending)
xlAscending
(xldescending)
xlDescending
(header = xlyes)
Header = xlYes
(header = xlno)
Header = xlNo
(setrange)
SetRange
(databodyrange)
DataBodyRange
(headerrowrange)
HeaderRowRange
(listcolumns)
ListColumns
(listrows)
ListRows
(on error goto 0)
On Error GoTo 0
(on error resume next)
On Error Resume Next
(debug.print)
Debug.Print
(ubound)
UBound
(redim)
ReDim