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

[solved] the cell a combo box is anchored to

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


Joined: 25 Nov 2005
Posts: 25

PostPosted: Mon Sep 20, 2010 11:33 am    Post subject: [solved] the cell a combo box is anchored to Reply with quote

Hi All,

I want to create a combo box in a basic macro.
I want to place and anchor the combo box in a cell on a sheet in calc.
I want to fill the cell with the combo box.
How do I do these things? Create, place, fill?

Really I want the cell to have a drop down list he can also type into for that cell.
So maybe I don't want a combo box.

Maybe there's a way I can use validation.
What are my alternatives?
What's the best way?

Thanks,
Ron
Back to top
View user's profile Send private message
ronhartikka
General User
General User


Joined: 25 Nov 2005
Posts: 25

PostPosted: Mon Sep 20, 2010 12:21 pm    Post subject: Reply with quote

Turns out validation works fine here.

I left Data->Validity->Error Alert blank.

The user gets a list but can type if he wants.

Plus the values goes straight in to the cell which is where I need it.
Back to top
View user's profile Send private message
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