Results 1 to 13 of 13

Worksheet Change Event code help

Threaded View

  1. #1
    Registered User
    Join Date
    02-10-2013
    Location
    UAE
    MS-Off Ver
    Excel 2010
    Posts
    26

    Question Worksheet Change Event code help

    Hi All,

    I would like the following to occur on my report:
    A change in value on cell B4 on Sheet1 runs a macro that changes cell X6 in Sheet2 (which is a hidden sheet) to the same value.

    I tried a sample code (below) putting B4 value on Sheet 2 and keeping it visible; and this worked but after changing the cell value of X6, it goes into "Calculate" mode, and the excel gets stuck such that I have to end the Excel process from windows task manager.

    /**
    Private sub worksheet_change(ByVal Target As Range)
    
    if intersect (target, range("B4")) is nothing then
    	if range("B4").value <> "(All)" then
    		range ("X6").value = range ("B4").value
    	end if
    end if
    End sub
    **/

    Any help/ ideas on how to get this done?? Thanx in advance.
    Last edited by arlu1201; 03-11-2013 at 07:11 AM. Reason: Use code tags in future.

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