Ladies and Gents,
I am having the most difficult time attempting to find any explanation on how I can access each item within a ComboBox.
I have created my own custom form (named “NewTransaction”) using LibreOffice Basic (v220.127.116.11). On it, I have a combobox named “cmbxCategory”. In my code module, I have the following code:
Function ShowDialog_NewTransaction Dim dialogBox_NewTrans As Object BasicLibraries.LoadLibrary("Tools") Set dialogBox_NewTrans = LoadDialog("Standard", "NewTransaction") With dialogBox_NewTrans With .GetControl("cmbxCategory") .addItem("Food", 0) .addITem("Drinks", 1) MsgBox .ListEntries(0) End With dialogBox_NewTrans.Execute() End With End Function
What I am ultimately after is to be able to call, at any time, the nth item in a combobox and store it into a string. Perhaps, I will want to assign “text” to be equal to the first item in the list. I understand that I may go out of bounds. Obviously, I receive an error on the MsgBox .ListEntries(0) line.
How can I set the chosen text to be equal to the nth item in the combobox list? How can I determine the number of elements in the combobox list so that I can prevent going out of bounds?
Also, I am considered an Expert at my job with regard to MS VBA, but for LibreOffice, I can’t seem to find any good documentation showing all available method calls, in this case, for a combobox. What would you recommend I reference when it comes to looking for various method calls?
Thank you for all your help!