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