Trying to add input box to code and use value in a counter

I want the input box to open upon the opening of the spreadsheet

If thats the case then you need to put your inputbox in the Worksheet_Activate event .

Worksheet_Change is fired when a value in a cell is changed. Your also going to want to become familiar with Application.EnableEvents = False and Application.EnableEvents = True Without these your going to end up in infinite loops in your Change events. In other words you add a value in you "Change Event " which triggers a change event ... which triggers a change event .... and on and on ... but Application.EnableEvents = False[/B] will turn the repeat of the trigger . See how I used it in my code .

Please Login or Register  to view this content.

You place the code into the sheet module of the relevant sheet

Worksheet event code is stored on a worksheet module. To add it to your worksheet, do the following:

Copy the code
Select the worksheet in which you the code to run
Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
Where the cursor is flashing, choose Edit | Paste

Hi sbernard
I'm trying to understand why you want to enter the number of Pallets in Cell E2. What's the overall objective...what's the value used for?

This code

Please Login or Register  to view this content.

will fire 1 time or 100 times, depending on how many entries the user makes in column 1 and column 2...how does that relate to the value in E2...what's it used for?

Also, you don't need to activate/ select the ranges

After your code selects C1, then the Target column must be 3, & the target column must be 2, so why check? Then your code checks again. Why is it activating those cells?

Please Login or Register  to view this content.