Unusual Request for Userform (Continued)

[ameritecc]

This is the user form in my workbook that is specific to each row of 183 rows and 13 identical takeoff worksheets. The user can change the status of a row item by filling in the quantity of any of these items. It doesn't have to be all or any of them. All of these items on this form is specific however to one piece of material entered on the same row. The open tab button is situated over a blank cell in the workbook and occurs in the same column on each 183 rows. I want the information entered in the white quantity text boxes to go to a specific user unaccessable calculation cell on the same row that the button is clicked on. From there I can tabulate it and incoporate it into the estimate.
I have had two answers on this request on how to identify the cell the button object sets over and one does bring up a message box with the cell address inclding the row. How to pull it back into the form for use is beyond me, and can I eliminate the message box from appearing so that I don't have to close it out?

The following code was supplied by the member Mikerickson to identify the address and it does work well. It is right on. Also XLD contributed some code that I am still working with and has given me some ideas. Can anyone add to this delimna?

VBA Code supplied by Mikerickson to get address:

Sub IdentifyButtonLocation()
MsgBox ActiveSheet.Shapes(Application.Caller).TopLeftCell.Address
End Sub

[Simon Lloyd]

Would it not have been better to keep all these threads together?

http://vbaexpress.com/forum/showthread.php?t=18154
http://vbaexpress.com/forum/showthread.php?t=18153
http://vbaexpress.com/forum/showthread.php?t=18096

[Bob Phillips]

We have given you all that we can on this subject from a distance. If you cannot apply it, and you cannot post the wrbook, we are stuck.

[ameritecc]

Well the Workbook is 50 Megabytes in Size. A mass of information including a list (Database) with over 300,000 cell entrys alone on one worksheet.
I am trying to take that address identifier in the message box, retrieve it from the message box, place it in a hidden text box on the form, and use it somehow as the locator for the row in which all the information in the open textboxes that is entered by the user, will apply their entries to. Right now it is the only approach I have, and I am having no success.