+ Reply to Thread
Results 1 to 5 of 5

HELP with Worksheet_Change(ByVal Target As Range)

  1. #1
    Registered User
    Join Date
    03-21-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    90

    HELP with Worksheet_Change(ByVal Target As Range)

    Hello All,

    I have this code that automates the worksheet based on changes made in certain cells. The issue I am having is when I click on any other empty cell I see the wheel run like it's running the macro again. However, this limits the ability for the user to copy and paste within the spreadsheet. Also, I can't insert a row if I try to. If I right click and try to insert a row then the menu will appear but disappear. It's the same thing when I click on a cell and right click to paste something in the cell the little circle appears like the macro is running and then the menu disappears.

    HTML Code: 
    Last edited by jadown; 02-16-2018 at 10:48 AM.

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: HELP with Worksheet_Change(ByVal Target As Range)

    I do not know how you manage to include two of the same events in one sheet.

    Private Sub Worksheet_Change(ByVal Target As Range)

  3. #3
    Registered User
    Join Date
    03-21-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    90

    Re: HELP with Worksheet_Change(ByVal Target As Range)

    Sorry that was a error when I paste the code in. I edited it.

  4. #4
    Registered User
    Join Date
    03-21-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    90

    Re: HELP with Worksheet_Change(ByVal Target As Range)

    I was able to get the copy and paste to show in the menu again by going to the immediate window and doing the commandbars(Reset). However I'm still running into the issue if I copy a cell in this same MAIN tab and click another cell on the MAIN tab whatever I had copied gets erased from the clipboard.

  5. #5
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: HELP with Worksheet_Change(ByVal Target As Range)

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Worksheet_Change (ByVal target As Range)
    By art_a_game in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-12-2016, 11:21 PM
  2. [SOLVED] Private Sub Worksheet_Change(ByVal Target As Range)
    By hmr2662 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-23-2015, 12:35 PM
  3. Replies: 5
    Last Post: 12-16-2014, 05:47 PM
  4. [SOLVED] Worksheet_Change(ByVal Target As Range) - set to only update when 3 target cells changed?
    By trillium in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2012, 06:40 PM
  5. Worksheet_CHange (ByVal Target as Range) when target is formula cell
    By coasterman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2012, 07:00 PM
  6. [SOLVED] use of Worksheet_Change(ByVal Target As Range)
    By Isaac in forum Excel General
    Replies: 2
    Last Post: 07-07-2006, 02:10 PM
  7. [SOLVED] Worksheet_Change(ByVal Target As Excel.Range)
    By Daggi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-29-2005, 10:05 AM

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