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

[µo°Ý] ¿é¤JÀx¦s®æ®É,«ö¤@¤U«ö¶s,¦p¦ó§â«ö¶s¦r¦ê¶Ç¨ì¸ÓÀx¦s®æ,ÁÂÁÂ.

[µo°Ý] ¿é¤JÀx¦s®æ®É,«ö¤@¤U«ö¶s,¦p¦ó§â«ö¶s¦r¦ê¶Ç¨ì¸ÓÀx¦s®æ,ÁÂÁÂ.

¿é¤JÀx¦s®æ®É,«ö¤@¤U«ö¶s,¦p¦ó§â«ö¶s¦r¦ê¶Ç¨ì¸ÓÀx¦s®æ,ÁÂÁÂ.
[C2]¿é¤J¥x¥_¥««á,«ö[¤¤¥¿°Ï]«ö¶s,[C2]Åܦ¨[¥x¥_¥«¤¤¥¿°Ï],¥B¦b¿é¤Jª¬ºA,¥i¥HÄ~Äò¿é¤J¨ä¥L¤å¦r,¥H¦¹Ãþ±À.

«ö¶s¶Ç¦r¦ê.rar (14.54 KB)

§ù¤p¥­

¤p§Ì¸Õ¤F¤@¤U¡AÀ³¸Ó¥u¯àº¡¨¬   [C2]¿é¤J¥x¥_¥««á,«ö[¤¤¥¿°Ï]«ö¶s,[C2]Åܦ¨[¥x¥_¥«¤¤¥¿°Ï]¡AµM«áªð¦^­è¤~¿é¤Jªº cell  
                            µLªkº¡¨¬           ¥B¦b¿é¤Jª¬ºA,¥i¥HÄ~Äò¿é¤J¨ä¥L¤å¦r



Sub «ö¶s1_Click()
    Area_1 = "¤¤¥¿°Ï"
    Now_row = ActiveCell.Row
    Now_col = ActiveCell.Column
    Cells(Now_row, Now_col) = "[" + Cells(Now_row, Now_col) + Area_1 + "]"
    Cells(Now_row, Now_col).Select
   
End Sub

Sub «ö¶s2_Click()
    Area_1 = "¤j¦P°Ï"
    Now_row = ActiveCell.Row
    Now_col = ActiveCell.Column
    Cells(Now_row, Now_col) = "[" + Cells(Now_row, Now_col) + Area_1 + "]"
    Cells(Now_row, Now_col).Select

End Sub

Sub «ö¶s3_Click()
    Area_1 = "¤¤¤s°Ï"
    Now_row = ActiveCell.Row
    Now_col = ActiveCell.Column
    Cells(Now_row, Now_col) = "[" + Cells(Now_row, Now_col) + Area_1 + "]"
    Cells(Now_row, Now_col).Select

End Sub

«ö¶s¶Ç¦r¦ê.zip (17.43 KB)

TOP

¦pªG­nº¡¨¬"¿é¤Jª¬ºA,¥i¥HÄ~Äò¿é¤J¨ä¥L¤å¦r"¡A§Ú¬O·Q¨ì¥Î sendkeys ¤è¦¡¡A°e¥X F2 Áä

TOP

µ²¦X¤G¦ì«e½ú«ü¾É,¨ü¯q¨}¦h
Sub «ö¶s3_Click()
    Area_1 = "¤¤¤s°Ï"
    Now_row = ActiveCell.Row
    Now_col = ActiveCell.Column
    Cells(Now_row, Now_col) = "[" + Cells(Now_row, Now_col) + Area_1 + "]"
    Cells(Now_row, Now_col).Select
    SendKeys "{F2}"
End Sub
SendKeys "{F2}"   ¬O§Úªº¶·¨D.·P®¦.
§ù¤p¥­

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD