Strange control in worksheet - can someone look at it ASAP?

[ChristineP]

I have a worksheet developed by someone else (no longer available) that I
have to modify. It has a number of combo boxes and, for the life of me, I
can't figure out how to edit them much less figure out how they were created.

The scroll bars only appear when the cell is selected, so it they weren't
created using the Forms toolbar. If they are ActiveX controls, then I can't
see their properties nor find out where the values are coming from. There are
no macros.

Would someone be willing to look at the worksheet for me? - This is driving
me crazy and I'm already way behind schedule!

Thanks,
Christine

[papou]

Hi Christine
From the Excel menu, have a look at Data Validation in the mentionned cells.
HTH
Cordially
Pascal

"ChristineP" <[email protected]> a écrit dans le message
de news:[email protected]...
> I have a worksheet developed by someone else (no longer available) that I
> have to modify. It has a number of combo boxes and, for the life of me, I
> can't figure out how to edit them much less figure out how they were
created.
>
> The scroll bars only appear when the cell is selected, so it they weren't
> created using the Forms toolbar. If they are ActiveX controls, then I
can't
> see their properties nor find out where the values are coming from. There
are
> no macros.
>
> Would someone be willing to look at the worksheet for me? - This is
driving
> me crazy and I'm already way behind schedule!
>
> Thanks,
> Christine
>

[ChristineP]

Ur....um, never mind - Just discovered they used Validation to create the list.

"ChristineP" wrote:

> I have a worksheet developed by someone else (no longer available) that I
> have to modify. It has a number of combo boxes and, for the life of me, I
> can't figure out how to edit them much less figure out how they were created.
>
> The scroll bars only appear when the cell is selected, so it they weren't
> created using the Forms toolbar. If they are ActiveX controls, then I can't
> see their properties nor find out where the values are coming from. There are
> no macros.
>
> Would someone be willing to look at the worksheet for me? - This is driving
> me crazy and I'm already way behind schedule!
>
> Thanks,
> Christine
>