- ©«¤l
- 2
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 2
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Pro
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-5-21
- ³Ì«áµn¿ý
- 2015-4-16
|
¦^´_ 2# Hsieh
§A¦n, §Ú·Q¥Î¤T¶¥°j°é¥h«ü©w¤@±ÆÀx¦s®æªºRGBÃC¦â
µ{¦¡¦p¤U,¦ý¬O¤@ª½¥X²{«¬ºA¤£²Å¦X,¦b«á±¥´¦n¦h¬P¬Pªº¨º¤@¦æ
¥i¥H½Ð±Ð°ÝÃD¦bþ¶Ü?
=========================================
Sub assign_color()
Dim i As Integer
Dim j As Integer
Dim k As Integer
Dim p As Integer
p = 3
For i = 0 To 255 Step 20
For j = 0 To 255 Step 20
For k = 0 To 255 Step 20
Range("A" & p).Value = p - 2
Range("B" & p).Value = i
Range("C" & p).Value = j
Range("D" & p).Value = k
Range("E" & p).Interior.Color = RGB(Cells("B", p).Value, Cells("C", p).Value, Cells("D", p).Value) **************
p = p + 1
Next
Next
Next
End Sub
========================================= |
|