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

label¤¤¬O§_¯à²£¥Í®æ¤l½u©O??

label¤¤¬O§_¯à²£¥Í®æ¤l½u©O??

¥»©«³Ì«á¥Ñ sillykin ©ó 2018-11-16 23:58 ½s¿è

¯à§_¦buserform¤ºlabel²£¥Í®æ¤l¡]¸ò¹Ïªí¤¤ªº¤@¼Ë¡^¶Ü??©ÎªÌ¦³°ª¤â´£¨Ñ­Ó·N¨£
¹Ï.JPG

12.rar (34.58 KB)

userform ¦Û±a¼ÐÂ઺±±¨î¶µ¸Ì­±´N¥u¦³ label ¤£¦æ

because it is no handle

TOP

ÁÂÁ¤j¤jªº¦^ÂÐ
·Q½Ð°Ý
=MID($A$45,(ROW(1:1)-1)*20+COLUMN(A:A),1)
¨ç¼Æ§ï¬°vba­n¦p¦ó§ï©O???
®æ¼Æ¦³160®æ

TOP

¦^´_ 1# sillykin

¥Î180­ÓLabel¨ÓÅã¥ÜTEXTBOXªº¤å¦r¤º®e
play.gif
2018-11-21 16:31

180¼ÐÅÒ.zip (20.7 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh


    ÁÂÁÂHsiehª©¥D
­ì¨Ó³o¼Ëªº¤è¦¡¥i¦æ,¦ý­n¤å¦r¸m¤¤,­n¦p¦ó³B¸m
¤£¬O¥[¤J .HorizontalAlignment = xlCenter '¤å¦r¸m¤¤¹ï»ô
¦ýÁÙ¬O°õ¦æ·|µo¥Í¿ù»~

TOP

¦^´_ 5# sillykin


        With Me.Controls.Add("forms.Label.1")
         .Top = t
         .Width = 20
         .Height = ct.Height
         .Left = ct.Left + ct.Width + (j - 1) * 20
         .Name = k
         .Object.BorderStyle = 1
         .Object.TextAlign = 2 '¸m¤¤
      End With
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : °ß¨ä´L­«¦Û¤vªº¤H¡A¤~§ó«i©óÁY¤p¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD