RE: [belajar-excel] ComboBox_Change

2012-01-29 Thread jkssxls Sudarsono
: [belajar-excel] ComboBox_Change Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Count = 1 Then If Target.Column = 4 Then If Target.Row > 1 Then ' pada saat posisi kursor di kolom D '

RE: [belajar-excel] ComboBox_Change

2012-01-29 Thread jkssxls Sudarsono
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Count = 1 Then If Target.Column = 4 Then If Target.Row > 1 Then' pada saat posisi kursor di kolom D ' agar nilai combobox1 sesuai dengan sel di kolom D 'tambahkan : ComboBox1.Value