Active Listbox/Combobox cell name

[johnnyideal]

Hi, I am using OO on a Win 8 and I have an invoice template that has a list-box for every line item part#. I run the same macro to insert the selected part#, description, price, etc. It current enters it in the next empty row. How could I get the cell name that contains the list-box used to select my part#. I would like to enter the data in the same row as the active list-box. I don't know what the version of OO. It was installed approx. 2 yrs ago. Any help is greatly appreciated. Thank you.

[Villeroy]

YOU are the programmer of that program. So do your job and DEBUG.

[johnnyideal]

That is the problem. I am not much of a programmer. I did that with the recorder.

[UnklDonald418]

Based on the information you provided it would be very difficult for anyone to offer much help. If you upload an example perhaps then someone can help.
To determine the version right click on Help and select About Open Office.

[johnnyideal]

I want to enter the selected item in the cell that the active list-box is located. I need to find which list-box was clicked and where it is anchored. Thank you

[UnklDonald418]

Looking at your example I'm impressed with how far you've been able to get with this, especially since most of the macros are recorded .
But in the end you are still trying to coerce a spreadsheet to do the job of a database.
Look at [Example] Invoice Forms (without macros)
viewtopic.php?f=100&t=56006

[johnnyideal]

Thank you. I actually tried a database before I did the spreadsheet, but I didn't understand queries. Maybe I can learn from your example. I would still like to go on with this spreadsheet though.