Floating Data Validation cell??
 

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

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
|
|

Floating Data Validation cell??
 

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....toolscustomizetoolbar 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" wrote:

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

Floating Data Validation cell??
 

Jim
I sent you the file to your hotmail address. Let me know if that is not
a valid address. Otto
"Jim Rech" wrote in message
...
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
|
|

Floating Data Validation cell??
 

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
"FSt1" wrote in message
...
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....toolscustomizetoolbar 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" wrote:

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

Floating Data Validation cell??
 

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


Otto Moehrbach wrote:

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

--

Dave Peterson

Floating Data Validation cell??
 

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

--
Jim
"Otto Moehrbach" wrote in message
...
Jim
I sent you the file to your hotmail address. Let me know if that is
not a valid address. Otto
"Jim Rech" wrote in message
...
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
|
|

Floating Data Validation cell??
 

TWIMC = To Whom It May Concern
<vbg

er,
vbg = Very Big Grin


Jim Rech wrote:

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

--
Jim
"Otto Moehrbach" wrote in message
...
Jim
I sent you the file to your hotmail address. Let me know if that is
not a valid address. Otto
"Jim Rech" wrote in message
...
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
|
|





--

Dave Peterson

Floating Data Validation cell??
 

Thanks Dave. That's what it is. Otto
"Dave Peterson" wrote in message
...
If it has a macro assigned to it, it sounds like a dropdown from the Forms
toolbar--well, to me anyway.


Otto Moehrbach wrote:

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

--

Dave Peterson