Hello all,
New user here!
I am new to coding in Excel (pretty much Excel itself) and do not have access to Access. I would like to create an ordering list for our consumables at work that:
- once you click on the item# column, a command window pops up and asks if you are ordering today. If you click yes another pop up will ask you amount being ordered and P.O. or credit card use (if P.O. selected, P.O.# should be asked). Another sheet, within the same workbook, will record the date, item name, P.O.# or credit card use and amount ordered, with a running $ total.
Is this possible? Thank you
System Configuration: Macintosh / Chrome 74.0.3729.157
Lets start by inserting a form, name it frmENTRY. place two text boxs on the form, named txtAMOUNT, and another named txtDESC. Place a button on the form, named btnSUBMIT.
START with that
We are going to build a form. We will not be using a worksheet for order entry, but will be building a "pop up" window to enter it in, just as you requested. If you need help getting the developer tab unlocked, post back.