Floating Data Validation cell??

[Otto Moehrbach]

Excel XP & Win XP
I'm helping an OP who has 2003.
She sent me a part of her file and it has something in it that I have not
seen before.
Her file has a number of what appears to be Data Validation cells, but they
are not DV cells. They are boxes (think borders) with a drop-down arrow
permanently placed at the right end of the box. Click on the down arrow or
anyplace in the box and you get a drop down list.
The box has a macro assigned to it that fires whenever an item in the list
is clicked on.
The file has no UserForms nor any event code in any sheet nor the workbook.
What is this thing? Thanks for your time. Otto

 

[Jim Rech]

Sounds like a toolbar but it would have code. Sure would be interesting to
see it.<g>

--
Jim
| Excel XP & Win XP
| I'm helping an OP who has 2003.
| She sent me a part of her file and it has something in it that I have not
| seen before.
| Her file has a number of what appears to be Data Validation cells, but
they
| are not DV cells. They are boxes (think borders) with a drop-down arrow
| permanently placed at the right end of the box. Click on the down arrow
or
| anyplace in the box and you get a drop down list.
| The box has a macro assigned to it that fires whenever an item in the list
| is clicked on.
| The file has no UserForms nor any event code in any sheet nor the
workbook.
| What is this thing? Thanks for your time. Otto
|
|

 

[FSt1]

hi
sounds like a sheet combo box. they are a control that floats on top of the
sheet.
they are programable and the code that it is running is assigned to the
combo box and should be visible in the sheet code.
on the menu bar....tools>customize>toolbar tab> check control toolbox.
a tool bar will appear with all the available controls. you can click and
drag any to the sheet. at the top or left end(depending on how it displays)
click the small triangle. this puts you in design mode. right click the combo
box then click view code from the pop up. you can also view properties where
you can change it;s appearence such as color, name, caption ect.

hope this clears up things for you.
regards
FSt1

 

[Otto Moehrbach]

Jim
I sent you the file to your hotmail address. Let me know if that is not
a valid address. Otto

 

[Otto Moehrbach]

FSt1
That's what is perplexing. There is no code in the sheet module. None
at all. Of any kind. Thanks for your time. Otto

 

[Dave Peterson]

If it has a macro assigned to it, it sounds like a dropdown from the Forms
toolbar--well, to me anyway.

 

[Jim Rech]

TWIMC - Forms toolbar combo boxes they turned out to be.

 

[Dave Peterson]

TWIMC = To Whom It May Concern
<vbg>

er,
vbg = Very Big Grin

 

[Otto Moehrbach]

Thanks Dave. That's what it is. Otto

If it has a macro assigned to it, it sounds like a dropdown from the Forms
toolbar--well, to me anyway.