' 매크로1 매크로

Option Explicit

Sub 매크로1()

'

' 매크로1 매크로

'

'

    Range("G3:G10").Select

    With Selection.Validation

        .Delete

        .Add Type:=xlValidateInputOnly, AlertStyle:=xlValidAlertStop, Operator _

        :=xlBetween

        .IgnoreBlank = True

        .InCellDropdown = True

        .InputTitle = ""

        .ErrorTitle = ""

        .InputMessage = ""

        .ErrorMessage = ""

        .IMEMode = xlIMEModeHangul

        .ShowInput = True

        .ShowError = True

    End With

    Range("G3").Select

    ActiveCell.FormulaR1C1 = "123"

    Range("G4").Select

    ActiveCell.FormulaR1C1 = "yyy"

    Range("G5").Select

    ActiveCell.FormulaR1C1 = "jjjj"

    Range("G6").Select

    ActiveCell.FormulaR1C1 = "uuuu"

    Range("G7").Select

End Sub