½Ð°Ý°ª¤ân±N¥H¤UDDE ¨C¤ÀÄÁ°O¿ý§ï¬°30¬í¦Û°Ê°O¿ý¤@¦¸n«ç§ï
- ©«¤l
- 7
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 12
- ÂI¦W
- 0
- §@·~¨t²Î
- window7
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- ¨Ó¦Û
- taipei
- µù¥U®É¶¡
- 2012-11-7
- ³Ì«áµn¿ý
- 2013-9-15
|
¥»©«³Ì«á¥Ñ GBKEE ©ó 2013-9-8 20:19 ½s¿è
C_C lai ¤j¤j:
³oÓ°Q½×°Ï¯u¤£¿ù~
§Ú¬O·s¾Ç¥Í,¦]Åv¤£¨¬,½Ð°Ý¥i¥H§â¦Û°Ê°O¿ý¨C¤ÀÄÁ©e¶R½æ§¡È.rarÀɮפΤ¸¤j½L¤¤DDE¬ö¿ý±H¦Ü¤U¦C«H½c¶Ü?
******·P¿E¤£ºÉ~~~
CA199·q¤W
³o¬O¤½¶}ªº½×¾Â,Ó¤HªºMail,½Ð¦bÓ¤H¸ê®Æ¸ÌÅã¥Ü |
|
¦æ°Ê¬O³Ì½ñ¹êªº©¯ºÖ
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¦^´_ 83# GBKEE
ÁÂÁ±z¡I
¥Ø«e¤âÀY¤Wªº¤T¥x¹q¸£³£¬O¶] 2010 ª©ªº¡A
¦pªG¦b¤WÀY¦A¦w¸Ë 2003 ª©¬O·|¶Ã±¼ªº¡C
§Ú·|·Q¿ìªk¥h§ä³¡ 2003 ª©¥»ªº¸Õ¸Õ¬Ý¡I |
|
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¦^´_ 81# GBKEE
ªí³æ (UserForm) ¶}±Ò«á¡A¬OµLªk¦A¶}±Ò¨ä¥¦ Excel ¤u§@ªí³æªº¡A
©Ò¥H¤§«e§Ú¤~·|«Øij¨Ï¥Î¨ä¥¦µ{¦¡¤u¨ã¨Ó¸Ñ¨M¦¹§xÂZ°ÝÃD¡C |
|
|
|
|
|
|
- ©«¤l
- 58
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 66
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-5-21
- ³Ì«áµn¿ý
- 2019-2-26
|
¦^´_ 79# GBKEE
G¤j§A¦n¡A§Ú·Q¤j¤j¦n¤H°µ¨ì©³¡AÀ°¦£¥Îvb¥´¥]¤@¤U¡A¦]¤p¦a¤âÃä¨S¦³Visual Basic¥i¥H¶Ü? Á Á¡C |
|
devidlin
|
|
|
|
|
- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¥»©«³Ì«á¥Ñ GBKEE ©ó 2012-10-16 16:03 ½s¿è
¦^´_ 78# devidlin
¨Ì55# ªºªþÀÉ «Ü²³æªº¦Û¤v½m²ß¬Ý¬Ý,
ªí³æn¥ý§Ë¦nªº,±Nµ{¦¡½X§ó·s¬°¦p¤U,¦sÀÉ«á¦A¶}±Ò¬Ý¬Ý.
ThisWorkbookµ{¦¡½X- Dim AA As New Application '·sªºExcel ª«¥ó
- Sub Workbook_Open()
- Application.Visible = False
- With AA
- .Visible = True
- .WindowState = xlNormal
- .Left = 242
- .Top = 59
- .Width = 648
- .Height = 401
- End With
- UserForm1.Show
- End Sub
½Æ»s¥N½X UserForm(ªí³æ)µ{¦¡½X- Dim Msg As Boolean
- Private Sub UserForm_Initialize() 'UserForm(ªí³æ) ªì©l¤Æ®Éªº¨Æ¥óµ{§Ç
- '½Ð¥ý¦bUserForm(ªí³æ) ¥[¤J4Ó Label±±¨î¶µ
- '¨t²Î¦Û°Ê©R¦W(Label1, Label2 , Label3 , Label4)
- '½Ð¦Û¦æ½Õ¾ã 4Ó Label±±¨î¶µ ªº¦ì¸m,ªø,¼e,°ª
- Dim i As Integer
- StartUpPosition = 0
- Top = 1
- For i = 1 To 4
- With Me.Controls("Label" & i)
- .TextAlign = 1 ' fmTextAlignCenter
- .Font.Bold = True
- .Font.Size = 15
- .SpecialEffect = fmSpecialEffectEtched
- End With
- Next
- End Sub
- Private Sub UserForm_Activate() 'UserForm(ªí³æ) Åã¥Ü®Éªº¨Æ¥óµ{§Ç
- Dim xlTile As String, S As String
- S = Space(5)
- Do Until Msg = True
- DoEvents
- If Time < #8:00:00 AM# Then
- xlTile = "©|¥¼¶}½L"
- ElseIf Time > #1:30:00 PM# Then
- xlTile = "¤w¦¬½L"
- Else
- xlTile = "Àç·~¤¤"
- End If
- If Not Msg Then Caption = Format(Now, "Dddddd ttttt ") & xlTile
- If xlTile <> "©|¥¼¶}½L" Then
- Label1.Caption = S & [sheet1!K1] & S & [ROUND(sheet1!K2,3)]
- Label2.Caption = S & [sheet1!L1] & S & [ROUND(sheet1!L2,3)]
- Label3.Caption = S & [sheet1!M1] & S & [ROUND(sheet1!M2,3)]
- Label4.Caption = S & [sheet1!N1] & S & [ROUND(sheet1!N2,3)]
- End If
- Loop
- End Sub
- Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) 'UserForm(ªí³æ) Ãö³¬®Éªº¨Æ¥óµ{§Ç
- Msg = True
- Application.Visible = True
- ThisWorkbook.Save
- Application.Quit
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 58
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 66
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-5-21
- ³Ì«áµn¿ý
- 2019-2-26
|
¦^´_ 77# GBKEE
G¤j§A¦n¡A¥i¥H¸Õ°µ1Ó½d¨Ò¨Ó°Ñ¦Ò¶Ü?ÁÂÁ¡C |
|
devidlin
|
|
|
|
|
- ©«¤l
- 58
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 66
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-5-21
- ³Ì«áµn¿ý
- 2019-2-26
|
¦^´_ 69# GBKEE
½Ð°Ýc¤j¡A¦¹excelÀÉ¡A¥i¥H¥´¥]¦¨¤@Ó°õ¦æÀɨӥζÜ? ÁÂÁ¡C |
|
devidlin
|
|
|
|
|