Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 | | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 | | |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 | | |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
how blank data validation cell after changing dependent cell? | Excel Discussion (Misc queries) | |||
Why does data validation not work when pasting data into a cell. | Excel Discussion (Misc queries) | |||
Floating toolbar and floating comment? | Excel Programming | |||
data validation to restrict input in cell based on value of cell above that cell | Excel Programming |