> I suppose I should say that I am VBS-ignorant.
Brian and I are less specialized. We're many_things-ignorant, but no matter, he
wasn't speaking VBS. That's VBA.
> Is there a way that you are aware of of doing this "through the GUI" like in
> XL or Access?
There's not, but you can add the values you want and they stay put until you
change them again in code. No need to respond to click events or the like.
Have a look here:
Manipulating Listbox and Combobox controls on slides
http://www.rdpslides.com/pptfaq/FAQ00439.htm
>
> Ken
>
> "Brian Reilly, MVP" wrote:
>
> > Ken,
> > Yes, that is perplexing in PPT, isn't it?
> > Let me skip the Access comparison and just focus on the XL solution
> > and then let you figure it out for yourself (vbg)
> >
> > The XL solution relies on a range either defined by cells or a range
> > name. We ain't got nuthin' like that in PPT. So whatcha gonna do?
> >
> > The simplest hardcoded method (don't ever tell anyone I know the word
> > "hardcoded") is to just write the list in the VBE e.g.
> >
> > Private Sub ComboBox1_DropButtonClick()
> > With ComboBox1
> > ..AddItem "One"
> > ..AddItem "two"
> > End With
> > End Sub
> >
> > If you want it not hardcoded, I think you'd have to grab the values
> > from a list in XL (or elsewhere) and loop thru the list and use
> > something like .additem strMyVariable.
> >
> > There could be other ways like storing a list off the screen and
> > calling that list within a userform.
> >
> > Not sure exactly what you are doing but I probably would call the XL
> > list from within PPT.
> >
> > Brian Reilly, MVP
> >
> > On Mon, 3 Oct 2005 13:26:12 -0700, Ken <(E-Mail Removed)>
> > wrote:
> >
> > >OK... I'm confused.
> > >
> > >I am trying to add a combox control to a ppt slide via the contols toolbar.
> > >
> > >I am able to add the combobox. But now I want to populate the list.
> > >
> > >I can't figure out how to do this. I know how to do this in excel (data
> > >validation) and in Access (bind a data source table to the control). FOr
> > >the life of me I can;t figure out how to do this simple thing in PPT combox
> > >control.
> > >
> > >Thanks!
> > >
> > >KEn
> > >
> > >I know how to do this in Access (bin
> >
>
-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ:
www.pptfaq.com
PPTools:
www.pptools.com
================================================
Similar Threads
