EXCEL VBA ¦p¦ó±N«½Æªºµ{¦¡¦X¨Ö¦A¤@°_
- ©«¤l
- 1018
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 1058
- ÂI¦W
- 0
- §@·~¨t²Î
- win7 32bit
- ³nÅ骩¥»
- Office 2016 64-bit
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2012-5-9
- ³Ì«áµn¿ý
- 2022-9-28
|
¦^´_ 1# ken2192 - Private Sub Worksheet_Change(ByVal Target As Range)
- Dim ddeString As String
- If Intersect(Target, Range("A5:A25")) Is Nothing Then Exit Sub
-
- If Target.Count = 1 And Len(Target.Cells(1).Value) > 0 Then
- Application.EnableEvents = False
-
- ddeString = "=XQCTS|Quote!'" & Target.Value
- With Target
- .Cells(1, 2).Value = ddeString & ".TW-Name'"
- .Cells(1, 3).Value = ddeString & ".TW-Bid'"
- .Cells(1, 4).Value = ddeString & ".TW-Ask'"
- .Cells(1, 5).Value = ddeString & ".TW-Price'"
-
- '²¤
-
- End With
-
- Application.EnableEvents = True
- End If
- End Sub
½Æ»s¥N½X |
|
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C
|
|
|
|
|