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

[µo°Ý] TextBox°ÝÃD

[µo°Ý] TextBox°ÝÃD

§Ú·Q§âA1Àx¦s®æªº¸ê®ÆÅã¥Ü¦btextbox¤W­±
µ{¦¡¦p¤U:

Private Sub TextBox1_Change()
With TextBox1
.Text = Sheet.[a1]
End Sub

¥i¬O°õ¦æ¤F¸ê®ÆÁÙ¬O¨S¦³Åã¥Ü¦b¤W­±
¬O­þ¸Ì¼g¿ù¤F¶Ü?
³Â·Ðª¾¹Dªº¤HÀ°§Ú¸Ñµª¤@¤U!!

¦^´_ 1# shadowming


    .Text = Sheet.[a1]
­n«ü©w²M·¡­þ­Ó¤u§@ªí
¦p²Ä1­Ó¤u§@ªí
Sheets(1).[A1]
¥Hªí¦W«h¬O
Sheets("Sheet1").[A1]
¥HCodeName«h¬°
Sheet1.[A1]
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

[ª©¥DºÞ²z¯d¨¥]
  • Hsieh(2010-7-16 23:07): ¤W¶Ç§AªºÀɮ׬ݬݧA¹Ïªí¸ê®Æ¨Ó·½¬O«ç»ò³]©wªº

¦^´_ 2# Hsieh

    picture.rar (99.13 KB)

ª©¥D
·PÁ±z¹ï©ó§Úµoªº°ÝÃD³£À°§Ú¸Ñµª
³o¬O§Ú°Ñ¦Ò±z³o´X¦¸ªº¸Ñµª§@¥Xªº¤@­Óªí³æ
¥i¬O¥X²{¤F¤@­Ó°ÝÃD
¨º´N¬O¦pªG§Ú¦bimageªº¹Ï¤W¥Î·Æ¹«ÂI¤@¤U
¦A±²°Ê±²¶b®É¡AÂIÀ»ªº¨º­Ó¹Ïªí±N¤£·|¦AÅÜ°Ê
¦Ó¥t¤@­Ó¨S¦³ÂIÀ»ªº¹Ïªí¤Ï¦Ó¨S°ÝÃD
³o¬Oµo¥Í¤°»ò°ÝÃD©O?
§Ú±NºI¹Ï©ñ¦bªþÀÉ
½Ð±zÀ°§Ú¬Ý¤@¤U

TOP

        ÀR«ä¦Û¦b : µoµÊ®ð¬Oµu¼ÈªºµoºÆ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD