combobox and workbook_change event

[leonidas]

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!

Please Login or Register  to view this content.

[Tom Ogilvy]

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
>
>

[witek]

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

[leonidas]

Hi,

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

[leonidas]

Hi,

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