| View previous topic :: View next topic |
| Author |
Message |
Ronca Newbie

Joined: 07 Aug 2008 Posts: 3
|
Posted: Tue Dec 21, 2010 2:43 am Post subject: Help for use of combobox |
|
|
Hello everyone,
I'm new to the forum and ask for your help.
I created a series of macros in Excel and I wanted to transfer them to Open Office but I have problems.
| Code: | Private Sub ComboBox2_Click()
Var = 2
Foglio3.ComboBox1.Clear
Do Until Foglio1.Cells(Var, 2).Value = ""
If Foglio1.Cells(Var, 3) = Foglio3.ComboBox2.Object Then
Foglio3.ComboBox1.AddItem Foglio1.Cells(Var, 2).Value
End If
Var = Var + 1
Loop
End Sub |
There are error on line using the combobox.
Can you help me?
Thanks
Mattia
PS
In the start of macro I insert:
| Code: | | Option VBASupport 1 |
|
|
| Back to top |
|
 |
B Marcelly Super User

Joined: 12 May 2004 Posts: 1414 Location: France
|
Posted: Tue Dec 21, 2010 6:47 am Post subject: |
|
|
Hi,
You are now on OpenOffice.org territory. You will have to learn the local dialects.
Go the new forum http://user.services.openoffice.org/en/forum/
Enter the section Macros and UNO API
Read these interesting links or threads :
- Basic Guide
- Survival Guide for the forum
- Need thorough documentation of OOo BASIC objects, etc.
Enjoy  _________________ Bernard
OpenOffice.org 1.1.5 fr / OpenOffice.org 3.4.1 en-US + langpacks, MS-Windows XP Home SP3
This forum is unusable, use instead Apache OpenOffice forums |
|
| Back to top |
|
 |
|