is it possible to use this out side of a form? (put it in a worksheet)

if it isn't I can move everything else on to the form but I just got the
worksheet setup and distributed the way I want it.

Also, is it possible to have more than one list for the drop-down + edit line
that would change based on a set of criteria like another combo box or list
box?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1

The combobox from the control toolbox toolbar allows editing and is available
for both userforms and worksheets.

--
Regards,
Tom Ogilvy


"blackbox via OfficeKB.com" wrote:

> is it possible to use this out side of a form? (put it in a worksheet)
>
> if it isn't I can move everything else on to the form but I just got the
> worksheet setup and distributed the way I want it.
>
> Also, is it possible to have more than one list for the drop-down + edit line
> that would change based on a set of criteria like another combo box or list
> box?
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...mming/200706/1
>
>

the combo drop-down edit box will allow the user to choose from one of the
list including a blank line they can type in but is not saved as part of the
drop down list.

to my knowledge you can't do that with a regular combo box, although if you
can, I'm much more familiar with the control toolbox and would love to go
that route

Tom Ogilvy wrote:
>The combobox from the control toolbox toolbar allows editing and is available
>for both userforms and worksheets.
>
>> is it possible to use this out side of a form? (put it in a worksheet)
>>
>[quoted text clipped - 4 lines]
>> that would change based on a set of criteria like another combo box or list
>> box?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1

with the control toolbox combobox, the user can type the entry into the
textbox portion and it becomes the value of the combobox. The entry isn't
added to the list.

There are properties to control the behavior of the combobox that can force
the user to match the list, but these can be set to allow any entry as well.

--
Regards,
Tom Ogilvy


"blackbox via OfficeKB.com" wrote:

> the combo drop-down edit box will allow the user to choose from one of the
> list including a blank line they can type in but is not saved as part of the
> drop down list.
>
> to my knowledge you can't do that with a regular combo box, although if you
> can, I'm much more familiar with the control toolbox and would love to go
> that route
>
> Tom Ogilvy wrote:
> >The combobox from the control toolbox toolbar allows editing and is available
> >for both userforms and worksheets.
> >
> >> is it possible to use this out side of a form? (put it in a worksheet)
> >>
> >[quoted text clipped - 4 lines]
> >> that would change based on a set of criteria like another combo box or list
> >> box?
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...mming/200706/1
>
>

couldn't figure out how to type in the combo box even with fmMatchEntryNone

i added a text box and added its linked cell to the source range of the combo
box, so it works but i would prefer it not be separated.

what am I doing wrong?

Tom Ogilvy wrote:
>with the control toolbox combobox, the user can type the entry into the
>textbox portion and it becomes the value of the combobox. The entry isn't
>added to the list.
>
>There are properties to control the behavior of the combobox that can force
>the user to match the list, but these can be set to allow any entry as well.
>
>> the combo drop-down edit box will allow the user to choose from one of the
>> list including a blank line they can type in but is not saved as part of the
>[quoted text clipped - 12 lines]
>> >> that would change based on a set of criteria like another combo box or list
>> >> box?

--
Message posted via http://www.officekb.com