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