Cant get VBA Code to work. Would appreciate help.

[Sierra1]

Hello,

I am a novice Excel/VBA user. I am trying to create an Excel worksheet for my job and I am stuck on the last Command Button. I will attach pictures of what I am trying to do and my "non-functioning" code. :crying:

What I am trying to do is enter a key name in D7 and the quantity issued in F7. When the "update inventory" Command Button is clicked i would like the inventory to automatically be adjusted on the "Key Inventory" sheet.

Any help would be greatly appreciated!

26788
26789

[royUK]

You need to attach an example of the workbook. Pictures aren't much help.

[royUK]

You need to attach an example of the workbook. Pictures aren't much help.

[snb]

In a worksheet you don't even need a button if calculation is automatic.

[Sierra1]

In a worksheet you don't even need a button if calculation is automatic.

If there is an easier way then I am all ears, Sir!!

Thank you!

[snb]

Your picture doesn't work at all.

[Sierra1]

I am not having much luck! Can I drag a copy of the workbook over to the forum?

I am not sure how to link the workbook to in here. I assume any link I post will go bad since the workbook is inside the Company network. Any other suggestions?

Thanks for your time so far, sorry I am clueless to all this.

[royUK]

You don't link it you attach a copy like you did the pictures. Remove any sensitive data first