The code below brings up a message box which identifies the address of a worksheet button which opens a form for user input. The input should put all the entries in this form in certain cells on the same row that is identified in the message box address. What the form allows is to differentiate task for material that may be same material from row to row.
Does anyone know how there might be a way to pull this message box address into the form in a way that I could use it to place all my textbox entries in the form on the same row.
Also this messagebox comes up first on the screen when you click on the form botton, and you have to close it out before the form pops up. I know this is normal, but I am also wanting have the information somehow run in the back ground, be pulled in by the form, recorded somehow (maybe in a hidden textbox, and used to manipulate where the user entries are recorded.
Also please keep in mind, I have this button on a total of 2400 rows in 12 different worksheets. One form design, and it does the same thing for each row.
I desperately need help.
MsgBox ActiveSheet.Shapes(Application.Caller).TopLeftCell.Address
'Set the cell to activate
Const StartUpCell = "TopLeftCell.Address"