Re: Combo Box "Selection" Get / Let
- From: "keepITcool" <xrrcvgpbby@xxxxxxxxx>
- Date: Fri, 09 Dec 2005 08:04:14 -0800
you are "missing" .listindex :)
note that the List(array) in a control is 0 Based.
to select the 3rd item:
combobox.listindex=2
hth
--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam
Vacation's Over wrote :
> I'm using a combo box with style set to only allow choices from the
> fixed list. the list is fed in as an array on form loading.
>
> Problem: I can't seem to get the syntax to
> highlight/select/boundvalue to get an initial election to show up
> instaed of a blank. Also need to be able to reset selection onscreen
> programatically based on other choices user makes on the form.
>
> simple version:
> Combobox1.list = array(1,2,3,4,5)
> Combobox1.___________ = 3 ' show "3"selected for initial form
>
> User clicks elsewhere on form
> Combobox1.___________ = 4 'selection should change to show 4
>
> I know I'm missing something simple...
> Combobox1.value = Combobox1.value + 1 ' syntax works??/
>
> since array is dynamic i have not resorted to testing listindex as it
> would require a search/match loop that should not be needed??
.
- Prev by Date: Re: Progamatically Formating Cells within VSTO for Excel Application Development using C#
- Next by Date: Re: Path not found error
- Previous by thread: Selection.Copy
- Next by thread: Re: Combo Box "Selection" Get / Let
- Index(es):
Relevant Pages
|
