OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Help for use of combobox

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API
View previous topic :: View next topic  
Author Message
Ronca
Newbie
Newbie


Joined: 07 Aug 2008
Posts: 3

PostPosted: Tue Dec 21, 2010 2:43 am    Post subject: Help for use of combobox Reply with quote

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
View user's profile Send private message
B Marcelly
Super User
Super User


Joined: 12 May 2004
Posts: 1414
Location: France

PostPosted: Tue Dec 21, 2010 6:47 am    Post subject: Reply with quote

Hi,
You are now on OpenOffice.org territory. You will have to learn the local dialects. Razz

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 Smile
_________________
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
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group