I will try to simplify this. Please let me know if more information is needed.
I have an extensive Excell Program which within it are 12 worksheets used for quantity takeoff of different types of material. Each worksheet has 200 rows that can be populated through various Forms. My problem lies in the fact that one form in particular called "Detail" is specific to each row and manipulates how the material listed in that row is treated and fabricated versus something identical to it in another row. I have all this solved except for one thing. My form open tab is positioned over a cell in each row so that the user will not confuse himself with which row he is identifying specific handling of a material item. If he wants to designate specific information such as painting etc for this piece of material on this row he simply clicks on the Detail tab and the form opens for his data input. All these form tabs and the form it opens in each row are identical in every respect.
At this point I am looking at creating 2400 forms to accomidate each row on 12 worksheets (200 x 12). This simply isn't acceptable in my book. Is there a way in VBA to use the one form I created, code it in such a way that once the tab for the "open form macro" is clicked on, for it to automatically define itself as to which row it is on? I feel I am missing something simple , but maybe not.