Hello everyone, I am pretty new to working with VBA with Excel. I've worked with a bunch of different coding languages but all pretty entry level. Anyways, I have been trying to make an inventory sheet for my place of employment (public library) that can do what we need. I have worked my way though most of it. Got it to send an email based on a cell, made a form for our employees to use, and set up our basic design. I am just stuck on a couple things.
1. I am using a combo box in my form for the items in our inventory. What I want to do is when we select an item in the list and hit submit I just want it to subtract one from a specific cell. Sounds simple I just don't know where to start.
2. The email macro is working quite well but, the IF statement I had working now just sends the email regardless when I had it sending only if there was something below its limit. I am not sure how to include code on here if anyone can help me out that would be great.
3. The last part is also with the email. I want it to send only the cells that are "low in stock" and what the stock is for those cells.
Thanks so much everyone hope to hear from you soon!
1. I am using a combo box in my form for the items in our inventory. What I want to do is when we select an item in the list and hit submit I just want it to subtract one from a specific cell. Sounds simple I just don't know where to start.
2. The email macro is working quite well but, the IF statement I had working now just sends the email regardless when I had it sending only if there was something below its limit. I am not sure how to include code on here if anyone can help me out that would be great.
3. The last part is also with the email. I want it to send only the cells that are "low in stock" and what the stock is for those cells.
Thanks so much everyone hope to hear from you soon!
