エクセル 50%の確率で1か0をランダムで出してくれる
=MOD(ROUND(RAND()*10+10,0),2) |
VBAでバッチを動かす(Sylpheedを宛先&件名付きで起動)
'参照設定:Windows Script Hpst Object Model Sub mail(subject As String) 'コマンドプロンプトを使うためのオブジェクト Debug.Print cmd 'A1から順番に結果を書き込む Set result = Nothing End Sub |
エクセル VBA 3列目のセルが変わったら、1行文の色を変える
Sub cellchange(Target) End Sub Sub row_color_change(Target)
'・行数を取得 '・変わったセルとカテゴリの文字を照合して 'Worksheets(fname).Activate '文字色を変える
|
VBA 入力フォーム
[昨日] [今日] [明日] [ yyyy/m/d(aaa)[▼] [挿入] ┌─────────────────────────┐ │ │ │ │ │ │ │ │ │ │ └─────────────────────────┘ [改行] [OK]
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' 'フォームを読み込んだら Private Sub UserForm_Initialize()
'dlist.Value = Format(Now(), "yyyy/m/d(aaa)") befor = 7 For i = 0 To 32 + befor dlist.AddItem "" dlist.List(i, 0) = "" dlist.List(i, 1) = Format(Now() + i - befor, "yyyy/m/d(aaa)")
Select Case Now() + i - befor Case Now(): dlist.List(i, 0) = "今日" Case Now() + 7: dlist.List(i, 0) = "来週" Case Now() - 7: dlist.List(i, 0) = "先週" Case DateAdd("m", 1, Now()): dlist.List(i, 0) = "来月" End Select Next i dlist.ColumnWidths = 30 dlist.TextColumn = 2 dlist.ListIndex = befor End Sub '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' '昨日を押したら Private Sub yday_Click() InsertText (day_cal(-1) & " ") End Sub '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' '今日を押したら Private Sub tday_Click() InsertText (day_cal(0) & " ") End Sub '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' '明日を押したら Private Sub tmday_Click() InsertText (day_cal(1) & " ") End Sub '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' '日付の計算 Function day_cal(num) day_cal = Format(Now() + num, "yyyy/m/d") End Function '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' '挿入を押したら Private Sub CommandButton1_Click() InsertText (Format(dlist.Value, "yyyy/m/d") & " ") End Sub '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' '改行を押したら Private Sub kaigyo_Click() InsertText (vbCrLf) End Sub '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' 'OKを押したら Private Sub SaveBtn_Click() ActiveCell.Value = TextBox Call ActibeClear(ActiveCell)
Unload Me End Sub |