Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook_change event | Excel Discussion (Misc queries) | |||
Event: Workbook_Change or Worksheet_Change | Excel Programming | |||
Change event for comboBox | Excel Programming | |||
MsgBox in Enter event causes combobox not to run Change event | Excel Programming | |||
Combobox on change event | Excel Programming |