Can I convert ComboBoxes to TextBoxes?

[PCLIVE]

Is there a way to convert a ComboBox to a Text Box? I've got a group of
Combo Boxes that are of the correct size and in the appropriate location on
my worksheet. If there was a way to convert these to Text Boxes, which is
what I need, it would be very helpful.

Thanks in advance.
Paul

[JulieD]

Hi Paul

AFAIK you can't (you can in Access, but that doesn't help you very much!).
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"PCLIVE" <[email protected]> wrote in message
news:[email protected]...
> Is there a way to convert a ComboBox to a Text Box? I've got a group of
> Combo Boxes that are of the correct size and in the appropriate location
> on my worksheet. If there was a way to convert these to Text Boxes, which
> is what I need, it would be very helpful.
>
> Thanks in advance.
> Paul
>

[PCLIVE]

Thanks Julie. I figured that was probably the answer. So I just recreated
the boxes manually.

It's good to see that someone picks up the trash. By that I mean, my
question did not go unanswered.

Thanks again.
Paul

"JulieD" <[email protected]> wrote in message
news:%[email protected]...
> Hi Paul
>
> AFAIK you can't (you can in Access, but that doesn't help you very much!).
> --
> Cheers
> JulieD
> check out www.hcts.net.au/tipsandtricks.htm
> ...well i'm working on it anyway
> "PCLIVE" <[email protected]> wrote in message
> news:[email protected]...
>> Is there a way to convert a ComboBox to a Text Box? I've got a group of
>> Combo Boxes that are of the correct size and in the appropriate location
>> on my worksheet. If there was a way to convert these to Text Boxes,
>> which is what I need, it would be very helpful.
>>
>> Thanks in advance.
>> Paul
>>
>
>