Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-12-2018, 07:36 AM
NoSparks NoSparks is offline Salary Structure Calculations Windows 7 64bit Salary Structure Calculations Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

Start by Using Option Explicit and declare the variables you use.

When using Worksheet_Change(ByVal Target As Range) use Target.


You think what you've got works because you changed the value in cell O8 and then the Tab key took you to P8 where ActiveCell.Previous happens to be the Target.
That's not the case when you use the left, upper or down arrow.
Replace all those ActiveCell.Previous with Target.

Writing values to the sheet will have this procedure calling itself over and over.
Look into disabling and re-enabling Events to prevent this.

Have a read of this.
Reply With Quote
  #2  
Old 05-14-2018, 08:35 AM
mpapreja mpapreja is offline Salary Structure Calculations Windows 10 Salary Structure Calculations Office 2016
Novice
Salary Structure Calculations
 
Join Date: May 2018
Posts: 9
mpapreja is on a distinguished road
Default

Thanks for your valuable advice. I will try to implement your suggestion but can you please elaborate your following suggestion:-

"Writing values to the sheet will have this procedure calling itself over and over.
Look into disabling and re-enabling Events to prevent this."

I will definitely take care for the suggestions related to cross posting in future.
Reply With Quote
Reply

Tags
basic, salary, structure



Similar Threads
Thread Thread Starter Forum Replies Last Post
Document structure PetrK Word 2 05-12-2017 07:25 AM
Salary Structure Calculations Calculating the “total” based on “salary” value and its “type” (multiple IF), Jamal NUMAN Excel 4 07-05-2016 12:34 AM
Salary Structure Calculations Structure chart jenny p PowerPoint 1 02-24-2016 09:14 AM
VLookup formula Problem (salary plus (commission x sales)) topgear2015 Excel 11 06-05-2013 09:02 PM
How to add more tel nos to contacts structure plainman007 Outlook 0 03-16-2010 02:16 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:10 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft