[Solved] Dialog Box Field for Entering Cell Range

[saleem145]

Hello,

Is there is a Dialog Box field in the dialog box designer for entering a range of cells. I should be able to move the mouse and click on a spreadsheet cell and have it pick up the appropriate cell addresses??

Thanks,

Saleem

[FJCC]

There is not a built in control for doing that, as far as I know, but here is an example I had stored of a standard command button that triggers a Range Selection macro. The code is not mine.

Edit: If you are writing in Python, implementing the Range Selection Listener is somewhat different. The code in the attached file in in Basic. In Python you implement the Listener as a class. See this thread http://www.oooforum.org/forum/viewtopic.phtml?t=7748

[saleem145]

This should be part of OpenOffice -- its a must have!! Thanks for your code!