Hi. I am trying my best to finish this stock sheet but I do not know how to use the same code for different cells
I need the same code that is used in cell B3 to be active in cells B4 & B5 but I need the alert at 6 on B4 and 10 in B5
If anyone can do this for me or guide me it would be amazing
cheers
Hi, Gunner_gav,
amend your procedure in ThisWorkbook like
although with only one sheet in the sample you might as well use Private Sub Worksheet_Change(ByVal Target As Range) behind Sheet1.
Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hi Holger
Sorry but I am not that great with excel at all, how do I get that code in the spreadsheet all I know is that I need to press alt & F11 to get to the code page, not sure what to do then. Sorry again
thanks
Gav
I managed to get the previous code window open by going to view and then selecting code, I then deleted the code that was in and replaced it by pasting the code you ahve sent me in but nothing happens when the lower figures are entered into the cells
Hi, Gav,
code is located in ThisWorkbook and works fine for me.
Ciao,
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks