Inventory Macro Needed

Hello ace2go,

Welcome to the Forum!

I made a few changes to your original layout. There is a single button for each "Row" that will enter all the data selected on all the sheets. The selections are now made using Check Boxes. This gives the user a good visual indicator of the choices made. A command button does not. The macro below is the one called by the "Enter" buttons.

Please Login or Register  to view this content.

Hello Winon,

Are there any error messages?

Hello Winon,

I assume you have macros enabled. The code doesn't contain anything that is not recognized by 2007 and should run.

Hello Winon,

I just thought of something. I used the English code names for the sheets which is "Sheet". You will probably need to use your languages default code names. I don't remember what yours are but in Dutch it is "Blad".

Hello Winon,

You're welcome. Have a good power nap.

Hello Winon,

Did you check "Sheet 3" after you ran the macro to see if the entries were transferred?

Hello Leith,

I did check Sheet 3, and never actually saw that your Code in fact appended the Data on Sheet 3 as it should. What sleepy eyes told me is that it is not working, because I did not delete the actual comments from the first four lines or so, where it stated "Data should go here, and here, etc & etc". My sincere apologies for that.

So in short, your code works fine except that it does not clear the Checkboxes, and that causes duplications. I have tried to "Fix" it, but cannot get it to clear the CheckBoxes, on Sheets 1 & 2 after Sheet 3 had been up-dated.

I have got the program running in "Compatability Mode", and all works well, but not the clearing of the CheckBoxes,
even if I save the file as Excel 2007.xlsm.

InventoryLaptopsverb.xlsmThe script worked great for the workbook that you submitted, but when I tried to alter it, it says "error 424, object required"

I also wanted to know if there was a way to make the data run into a second form sheet after it hits so many fields going down, example - I add 20 items to the form and
the next 20 cascade onto the next form worksheet.

I also wanted to get rid of the checkboxes being checked after executing...

THANK YOU for all of your help, I cannot believe you accomplished all that I asked before with the compiled code you submitted before! I wish I had descriptions about each section of code so I understand how it does what it does :0)