VBA
関連タイピング
-
chatGPTに作らせた部分一致検索サイトです。
プレイ回数1020長文590打 -
全文字タイピング練習(108文字×100問,2分間ランダム)
プレイ回数3699英語長文120秒 -
プログラミングで良く使う英単語、構文のタイピングです！
プレイ回数3274短文英字429打 -
C言語を用いた記号・数字のタッチタイピング練習です。
プレイ回数1822英語長文220打 -
プレイ回数742短文9打 -
HTML＆CSSを忘れないために
プレイ回数2.6万英語長文759打 -
慣れていないと難しいかも
プレイ回数5389681打 -
タッチタイピングをマスターしたい方向けの問題です。
プレイ回数7346長文251打
問題文
(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