combobox and workbook_change event
 

Hi,

I have a macro (see the code below) which changes the values of cell
W14 to W24 when cell W13 (range("KolomWFunderingWon")) is changed. Whe
I insert anything at all in cell W13 the cells W14 to W24 are changed
but when I use a combobox and the linkedcell of that combobox is W1
and I choose something in the combobox so the value of cell W13 i
changed, nothing happens!
Is it possible to change cells W14 to W24 by using a combobox? Thank
in advance for helping me!


Code
-------------------
Private Sub Worksheet_Change(ByVal Target As Range)

If Range("KolomWFunderingWon").Value < "" Then
Range("W14:W24").Value = Range("KolomWFunderingWon").Value
End If

End Su
-------------------

--
leonida
-----------------------------------------------------------------------
leonidas's Profile: http://www.excelforum.com/member.php...fo&userid=3537
View this thread: http://www.excelforum.com/showthread.php?threadid=56109

combobox and workbook_change event
 

Why not use the click event of the combobox.

--
Regards,
Tom Ogilvy


"leonidas" wrote:


Hi,

I have a macro (see the code below) which changes the values of cells
W14 to W24 when cell W13 (range("KolomWFunderingWon")) is changed. When
I insert anything at all in cell W13 the cells W14 to W24 are changed,
but when I use a combobox and the linkedcell of that combobox is W13
and I choose something in the combobox so the value of cell W13 is
changed, nothing happens!
Is it possible to change cells W14 to W24 by using a combobox? Thanks
in advance for helping me!


Code:
--------------------
Private Sub Worksheet_Change(ByVal Target As Range)

If Range("KolomWFunderingWon").Value < "" Then
Range("W14:W24").Value = Range("KolomWFunderingWon").Value
End If

End Sub
--------------------


--
leonidas
------------------------------------------------------------------------
leonidas's Profile: http://www.excelforum.com/member.php...o&userid=35375
View this thread: http://www.excelforum.com/showthread...hreadid=561090

combobox and workbook_change event
 

leonidas wrote:
Hi,

I have a macro (see the code below) which changes the values of cells
W14 to W24 when cell W13 (range("KolomWFunderingWon")) is changed. When
I insert anything at all in cell W13 the cells W14 to W24 are changed,
but when I use a combobox and the linkedcell of that combobox is W13
and I choose something in the combobox so the value of cell W13 is
changed, nothing happens!
Is it possible to change cells W14 to W24 by using a combobox? Thanks
in advance for helping me!


Code:
--------------------
Private Sub Worksheet_Change(ByVal Target As Range)

If Range("KolomWFunderingWon").Value < "" Then
Range("W14:W24").Value = Range("KolomWFunderingWon").Value
End If

End Sub
--------------------


use combobox_change event instead of worksheet_change event

combobox and workbook_change event
 

Hi,

I cannot use the combobox_change or combobox_click event, because whe
I insert a row above this combobox in my worksheet I also have a macr
that inserts a new combobox in this inserted row and the comboboxe
below are rename like "combobox i = combobox i+1". So when I insert
row, the wrong combobox should be changed to do the trick. That's wh
I'd like to change cells W14 to W24 by a worksheet_change event. Do yo
have any solutions?
Thanks in advance

--
leonida
-----------------------------------------------------------------------
leonidas's Profile: http://www.excelforum.com/member.php...fo&userid=3537
View this thread: http://www.excelforum.com/showthread.php?threadid=56109

combobox and workbook_change event
 

Hi,

I have solved the problem by using a worksheet_calculate event instead
of the worksheet_change event.


--
leonidas
------------------------------------------------------------------------
leonidas's Profile: http://www.excelforum.com/member.php...o&userid=35375
View this thread: http://www.excelforum.com/showthread...hreadid=561090