ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¦p¦ó±NAA¸ê®Æªí¤ºªºActivex±±¨î¶µªºTextBox©MComboBox1 ²MªÅ

¦p¦ó±NAA¸ê®Æªí¤ºªºActivex±±¨î¶µªºTextBox©MComboBox1 ²MªÅ

Private Sub Workbook_Open()
With Sheets("AA")
    TextBox2 = ""
    TextBox4 = ""
    ComboBox1 = ""
End With
End Sub

¥H¤W¤£·|¥X²{¿ù»~¡A¦ý¬O¨S¦³®ÄªG

Private Sub Workbook_Open()
With Sheets("AA")
    TextBox2.Value = ""
    TextBox4.Value  = ""
    ComboBox1.Value  = ""
End With
End Sub

¥H¤W·|¥X²{¿ù»~

¦^´_ 1# av8d
¦h¬Ý¬Ý,µ{¦¡½Xªº¼gªk
  1. Option Explicit
  2. Private Sub Workbook_Open()
  3.     With Sheets("AA")    'ª«¥ó
  4.         .TextBox2 = ""    ' ¥[¤W  .  ªí¦¹ª«¥óªº¤lª«¥ó¦¨­û
  5.         .TextBox4 = ""
  6.         .ComboBox1 = ""
  7.     End With
  8. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

        ÀR«ä¦Û¦b : «Î¼e¤£¦p¤ß¼e¡C
ªð¦^¦Cªí ¤W¤@¥DÃD