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

[µo°Ý] ¦p¦óÅý¤U©Ô¿ï³æ¿ï¨ú«á¦Û°Ê¸õ¨ìÀx¦s®æ¬Û¹ïÀ³³B?

¦^´_ 7# c_c_lai

§Ú¤U¸ü§AªºÀɮסAÂI¿ïSheet2 - A2¨S¦³¥X²{¤U©Ô¿ï³æ¡A
½Ð°Ý§ÚÁٻݭn°µ­þ¨Ç³]©w¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 10# c_c_lai

ÁÂÁ§A´£¨Ñ¨º»ò¸Ô²Óªº»¡©ú

§ÚªºEXCEL¶}±Ò(¦w¥þ¦P·N¤]¶}±Ò)¤]¨Ì·Óµe­±¨BÆJ¥hÂI¿ïA2¡A¥i¬O¨S¦³¥X²{¤U©Ôªí¡A¬O§_§Ú¯Ê¤Ö¤°»òª«¥ó

Y+.jpg
2013-11-6 10:36
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 10# c_c_lai

§ÚªºEXCEL¬O2007
¶}±Ò§AªºÀɮסA¨ä¤u§@ªí¦WºÙ¬O Sheet1¡B Sheet2¡B Sheet3
¦ýVBAµ{¦¡¤¤¥Îªº¤u§@ªí¦WºÙ¬O ¤u§@ªí1¡B¤u§@ªí2
§Ú¸ÕµÛ±N VBA¤¤ªº "¤u§@ªí" §ï¬° "Sheet" ¤]¤£¦æ
¸Ó¦p¦ó¬O¦n  

¨Ò¦p
Sub CellValidation()      '  stillfish00 ´£¨Ñ
    With Sheets("¤u§@ªí2").[A2:A25].Validation
        .Delete
        .Add Type:=xlValidateList, Formula1:="=¤u§@ªí1!$A$3:$A$20"
    End With
End Sub
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 14# c_c_lai

ÁÙ¬O¤£¦æ¡A«öA2¡BA3...³£¨S¦³¤ÏÀ³
¤§«e¼Ó¥DªºÀɮפ]¤£¦æ¡A«á¨Ó§Ú¦Û¦æ³]©w ¸ê®ÆÅçÃÒ(²M³æ) ¡A¤U©Ô¿ï³æ¤~¥X²{

½Ð°Ý ComboBox1 ¬O§_»Ý­n¦Û¦æ¼W³]¡AÁÙ¬Oµ{¦¡¤w¸g¤º©w´N¦³
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 18# c_c_lai


¶}±Ò #1 ªºªþ¥ó¡AµM«á±Nµ{¦¡½X¶K¤J¨ì Sheet2 ªºµ{¦¡½X°Ï¡AÁÙ¬O¤£¦æ

¦Û¦æ³]©w ¸ê®ÆÅçÃÒ «á¡A¬O¥i¥H°õ¦æ¡A¤U©Ô¿ï³æ - ¿ï§¹¦Û°Ê¸õ¨ì CÄæ¼Æ¶q - ¿é¤J¼Æ¶q¤]¦Û°Ê¸õ¨ì¤U¤@¦C¡C
¥i¬O¤U©Ô¿ï³æ¤S¦n¹³¤£¬O ¸ê®ÆÅçÃÒªº¤U©Ô¿ï³æ¡AÀ³¸Ó¬OComboBox1±o¤U©Ô¿ï³æ

§Ú¦Û¤v¥Î¸ê®ÆÅçÃÒ°t¦XWorksheet_Change¤]¥i¥H¹F¨ì®ÄªG¡A¥u¬O¸ê®ÆÅçÃÒ¿ï³æ¥\¯à¤ñ¸û¶§¬K¡C
Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 1 Then
        Target.Offset(, 2).Select
    ElseIf Target.Column = 3 Then
        Target.Offset(1, -2).Select
    End If
End Sub

¬Û¤ù¿é¥X»ù¥Øªí_ML089.rar (31.27 KB)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 20# c_c_lai

A2§¹¥þªÅ¥Õ¡A¨S¦³§A¹Ï¤W¦h¥X¨Óªº¿ï³æ

­Y¶}°_ ³]­p¼Ò¦¡ «á ¤~·|¬Ý¨ì COMBOBOXª«¥ó

Y+.jpg
2013-11-6 16:10
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 21# c_c_lai

¬JµM¥Î COMBOBOXª«¥ó
¥i§_±N ³W®æ¦WºÙ¡B¤Ø¤o¡B³æ»ù ¦X¨Ö©ó¤U©Ô¿ï³æ¤¤Åã¥Ü¡A
¿ï¤¤«á ³W®æ¦WºÙ¡B¤Ø¤o¡B³æ»ù ª½±µ¼g¦ÜÄæ¦ì¤¤¡A
³o¼Ë·|§ó±M·~·P¤@¨Ç¡C

¤£¦n·N«ä¡A°½°½¥[½X¤@¤U
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 21# c_c_lai

¹Ï¤@¡A´N¬O§Ú­ì¥ý»¡ªº¡A¦n¹³­n³] ¸ê®ÆÅçÃÒ - ²M³æ¡A³o¼Ëµ{¦¡¤~¯à±Ò°Ê¡C

¹Ï¤G¡A¤º®e¬Û¦P
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 24# c_c_lai

¨S¿ù¦b ¾Þ§@¼Ò¦¡ ¤§¤U¡A¨S¦³¥X²{¤U©Ô¿ï³æªº¤T¨¤²Å¸¹¡A´N¬O¤@¯ëªÅ¥Õ

¦b ³]­p¼Ò¦¡ ¤§¤U¦³¬Ý¨£ COMBOBOX ª«¥ó

¥i¯à¬O§ÚEXCEL 2007ªº°ÝÃD¶Ü? ½Ð°Ý§A¥Îªº¬O´XªO?
­YÂà¦s¬° 2003ªO¥i¥H¥Î¶Ü ? µ¹§Ú¸Õ¸Õ¬Ý
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 3# stillfish00


  ½Ð°Ý stillfish00¤j ¤Î av8d¤j
§A­Ì¥i¥HTEST 19¼Ó©Î20¼ÓªºÀÉ®×¥i¥H¥¿±`¨Ï¥Î¶Ü?
§Úªº¤U©Ô¿ï³æ¤@ª½¥X¤£¨Ó

·PÁÂ
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD