Tecnologia, programação e muito Visual FoxPro.

quarta-feira, 30 de abril de 2014

Re: ]] XL-mania [[ Refresh color - macro

 

Coba tambahkan macro ini di VBE Sheet (Sheet1):
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Column >= 3 And Target.Column <= 6 Then
        If Target.Row >= 5 And Target.Row <= 10 Then
            Range("C14:F18").FormulaR1C1 = "=ColorFunction(RC2,R5C:R9C,TRUE)"
        End If
    End If
End Sub

Salam,
HK
On Monday, 28 April 2014, 22:10, "Pujiono, Setyo" <setyo.pujiono@philips.com> wrote:
 
Dear Excel Guru's
Sy coba untuk menghitung  produk capacity dgn base color function dengan menambahkan macro dan ternyata berhasil. Namun ketika sy mengganti color di capacitynya, ternyata di perlukan satu macro unutk merefresh total colorfunction nya. Udah coba bikin macro, cuman hasil keluar dari area diimana cell yang di harapkan.
 
Option di excel untuk formula udah otomatis.
 
Mohon bantuan nya Gan, unutk create macro yang mana jika sy mengganti capacity color, refresh product output qty akan terhitung .
 
Thanks.
 
Best Regards,
 
Setyo Pujiono
 
 


The information contained in this message may be confidential and legally protected under applicable law. The message is intended solely for the addressee(s). If you are not the intended recipient, you are hereby notified that any use, forwarding, dissemination, or reproduction of this message is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender by return e-mail and destroy all copies of the original message.


__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)

Now you can search Photos & Files in your Group !
You can now search for photos and files in your Yahoo Group, in addition to searching for messages in your Group archive

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Maaf moderasi terlambat karena yahoogroups sering error           |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di :                                            |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

.

__,_._,___

Nenhum comentário:

Arquivo do blog