VBA

関連タイピング
-
C言語を用いた記号・数字のタッチタイピング練習です。
プレイ回数1575英語長文220打 -
JAVAの練習用です。
プレイ回数1206長文120秒 -
全記号数字タイピング練習(108文字×100問,2分間ランダム)
プレイ回数6797英語長文120秒 -
コマンドラインやプログラミング言語のタイピング練習用
プレイ回数1631英語長文90秒 -
タイトル通り。
プレイ回数299英語744打 -
キーボードにある記号全て使います!!
プレイ回数2835英語60秒 -
WEB系エンジニア向け
プレイ回数1901英語長文1462打 -
プログラミング用のタイピング練習
プレイ回数5032英語長文300秒
問題文
(dim fpath as variant)
dim fpath as variant
(numwide=strconv(i,vbwide))
numwide=strconv(i,vbwide)
(msgbox format(a,"yyyy/mm"))
msgbox format(a,"yyyy/mm")
(set wb=activeworkbook)
set wb=activeworkbook
(for i=1 to sheets.count)
for i=1 to sheets.count
(cells(rows.count,"a").end(xlup).row)
cells(rows.count,"a").end(xlup).row
(for each ws in wb.worksheets)
for each ws in wb.worksheets
(rows("1:1").wraptext=true)
rows("1:1").wraptext=true
(activewindow.freezepanes=true)
activewindow.freezepanes=true
(activesheet.copy)
activesheet.copy
(sheets(1).copy after:=sheets(1))
sheets(1).copy after:=sheets(1)
(if activesheet.autofiltermode=true)
if activesheet.autofiltermode=true
(for each i in thisworkbook.sheets)
for each i in thisworkbook.sheets
(debug.print i.name)
debug.print i.name
(selection.value=selection.value)
selection.value=selection.value
(byval target as range)
byval target as range
(call userform1)
call userform1
(application.displayalerts=false)
application.displayalerts=false
(application.cutcopymode=false)
application.cutcopymode=false
(activeworkbook.close)
activeworkbook.close
(if typename(selection)<>"range")
if typename(selection)<>"range"
(application.dialogs(xldialogsaveas).show)
application.dialogs(xldialogsaveas).show
(range("b2").autofilter 2, "<>")
range("b2").autofilter 2, "<>"
(createobject("scripting.filesystemobject"))
createobject("scripting.filesystemobject")
(activeworkbook.saveas path)
activeworkbook.saveas path
("=datedif(rc[-2],rc[-1],""y"")")
"=datedif(rc[-2],rc[-1],""y"")"
(range("c3:d8").select)
range("c3:d8").select
(specialcells(xlcelltypeconstants,23))
specialcells(xlcelltypeconstants,23)
(workbooks.add)
workbooks.add
(activesheet.printpreview)
activesheet.printpreview
(fittopageswide)
fittopageswide
(fittopagestall)
fittopagestall
(numberformatlocal)
numberformatlocal