Results 1 to 5 of 5

combobox and workbook_change event

Threaded View

  1. #1
    Registered User
    Join Date
    06-13-2006
    Posts
    76

    combobox and worksheet_change event

    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!

    Private Sub Worksheet_Change(ByVal Target As Range)
    
    If Range("KolomWFunderingWon").Value <> "" Then
      Range("W14:W24").Value = Range("KolomWFunderingWon").Value
    End If
    
    End Sub
    Last edited by leonidas; 07-13-2006 at 10:31 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1