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

[µo°Ý] textbox¥i½Æ¿ï

[µo°Ý] textbox¥i½Æ¿ï

¦b¦Û©wªí³æ
textbox ©Î combobox ¥i¥H½Æ¿ï¶Ü?
¨D§U¦U¦ì°ª¤â
ÁÂÁÂ!
max

¦b¦Û©wªí³æ
textbox ©Î combobox ¥i¥H½Æ¿ï¶Ü?
¨D§U¦U¦ì°ª¤â
ÁÂÁÂ!
user999 µoªí©ó 2011-12-5 17:10



    §Aªº·N«ä¬O¦P®É¿ï¤W¦h­ÓTEXTBOX?
³o¼Ëªº¸Ü©Î³\¥i¥H¥Î CHECKBOX¨Ó¨ó§U
20111205twbtsformcbk.jpg
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

½Ð°Ýkimbal¤j¤j¡A¦p±z©Ò¥Ü¡A¤@­Ócheckbox©M¤@­Ótextbox¦X°_¨Ó¡A¥i¥H¼g¤J¤@­ÓÀx¦s®æ¤¤¶Ü?
·Ð½Ð¤j¤j«üÂI
ÁÂÁÂ!

TOP

½Ð°Ýkimbal¤j¤j¡A¦p±z©Ò¥Ü¡A¤@­Ócheckbox©M¤@­Ótextbox¦X°_¨Ó¡A¥i¥H¼g¤J¤@­ÓÀx¦s®æ¤¤¶Ü?
·Ð½Ð¤j¤j«üÂI
ÁÂ ...
sammay µoªí©ó 2011-12-9 09:03



    °ÝÃD¬O­n¼g¨Ç¤°»ò¨ì¤@­ÓÀx¦s®æ¤º

³o1¬q§â checkboxªº­È ©M textboxªº­È ¥Î";" ³s°_¨Ó
    Dim strResult As String
    If CheckBox1.Value Then
        strResult = "-1"
    Else
        strResult = "0"
    End If
    strResult = strResult & ";" & TextBox1.Value
    Range("A1").Value = strResult

³o¤@¬q¥i¥H§â¤§«e©ñ¦b("A1")ªº­È©ñ¦^¨â­Ó±±¥ó
    Dim strInput As String
    strInput = Range("A1").Value
    CheckBox1.Value = Val(Split(strInput, ";")(0))
    TextBox1.Value = Split(strInput, ";")(1)
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¦^´_ 4# kimbal
·PÁÂkimbalªº¦^ÂСG
§Úªº·Qªk¬O¡G¨Æ¥ý¦btextbox¿é¤J©T©wªº­È¡AÅý¨Ï¥ÎªÌ¤Ä¿ïcheckbox«á¡A¶ñ¤J¤@­ÓÀx¦s®æ¤¤(¶ñ¤Jtextboxªº­È)
¤£ª¾¬O§_¥i¦æ¡A½Ðkimbal¤j¤j«üÂI

TOP

¦^´_ 5# sammay
play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁ¦U¦ì°ª¤âªº«ü¾É,§Ú¥»·N¤ñ¸û·Q­n¤@­Ó¤U©Ô¦¡¿ï³æ¥i¥H°µ½Æ¿ï,¦³³o¼Ë¥\¯à¶Ü?ÁÂÁÂ!
max

TOP

¦^´_ 6# Hsieh
·PÁÂHsieh¤j¤jªº¦^ÂСA¤S¾Ç¨ì¤@©Û¡A¨ü¥ÎµL½a¡C:handshake

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2011-12-10 01:25 ½s¿è

³o¸Ì¦³¤@­Ó¼W¯q¶°¤u¨ã
¤w¸g©ñ«Ü¤[¤F
À³¸Ó«Ü²Å¦X±zªº»Ý¨D
¬Ý§A´Nª¾¹D

¾Þ§@¤W
½Æ¿ï¤èªk
  1.¥i¦bTEXTBOX¤W¨Ï¥Î·Æ¹«©¹¤U©Ô
  2.«ö¦íSHIFT¤£©ñ¦bTEXTBOX¤W¨Ï¥Î·Æ¹«ÂI¿ï
  3.«ö¦íCTRL¤£©ñ¦bTEXTBOX¤W¨Ï¥Î·Æ¹«ÂI¿ï
½Ð¦Û¦æ´ú¸Õ


http://forum.twbts.com/viewthrea ... %C6%BF%EF%BF%E9%A4J

TOP

¦^´_ 9# HUNGCHILIN


    ÁÂÁÂ
§Ú·Q°µ¦pªþ¥[¥ó ¨Ó·½SOURCE ¥Ò¶µ...¦h¿ï µ²ªG¦s¦^ result sheets ¥ÒÄæ¤AÄæ ªì¾ÇÁÙºN¤£¥X ¥i½Ð¦U¦ì±M®aÀ°¦£,ÁÂÁÂ!

½Æ¿ï2.rar (13.88 KB)

max

TOP

        ÀR«ä¦Û¦b : ªY½à§O¤H´N¬O²øÄY¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD