This is the code I'm using for running inventory, which I copied from another post. It works fine until I close out Excel, but on restart it does not work. I have no experience in writing code. Any help would be appreciated.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 6 And Target.Cells.Count = 1 Then
Target.Offset(0, 1).Value = Target.Offset(0, 1).Value + Target.Value
End If
End Sub
That code needs to go into the codemodule of the worksheet:
1) Copy the code.
2) Right-Click the sheet tab of interest.
3) Select "View Code"
4) Paste the code into the window that appears.
5) Save the file as a macro-enabled .xlsm file (if using XL2007 or later).
Make sure you have macros enabled when you re-open the workbook.
Please Login or Register to view this content.
Bernie Deitrick
Excel MVP 2000-2010
Hi Ronald,
It seems Bernie is telling you where to put your code. Read this site for better info:
http://www.cpearson.com/excel/codemods.htm
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thanks! I had the code in the right place... I just wasn't saving it correctly. Thanks so much for the assistance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks