View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Floating Data Validation cell??

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

--
Jim
"Otto Moehrbach" wrote in message
...
| 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
|
|