What is the equivalent of Excel's RefEdit in Libre's Dialog form?

[sargdavid]

Hello,

I was trying to recreate in Libre Calc a UserForm I made in Excel. Everything seems to be fine except I cannot find any control to get cell references, i.e. functionality provided by RefEdit control in Excel. Is there anything like that? If not, can any other control be twigged into accepting cell references in a similar way? For those not familiar with the RefEdit, the control allows inputting cell addresses by selecting the ranges while the UserForm is open.

P.S.
I found a webpage describing coding a RefEdit-like control:

DevBlogs

Can this be adopted for LibreOffice?

[mariosv]

Maybe you can find help in this web page.

https://help.libreoffice.org/Common/Data#Linked_cell

[sargdavid]

Unless I’m missing something, the info on that page is unrelated to my question. Just to make it a little clearer, here are the link to the RefEdit page:

http://support.microsoft.com/kb/213776

Here is the discussion for RefEdit control in .NET.

I could probably adopt this code but if there is a cleaner solution I’d rather use that.

[mariosv]

Sorry, but I can’t help with it.

[sargdavid]

that’s OK, thank you for trying

[mariosv]

Maybe a good place to find information is https://wiki.documentfoundation.org/Macros