Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi--
I have three columns which have data validation list boxes attached, so = that=20 when you click on a cell a little handle appears and you select a name = from=20 the list box that appears. In one of the columns, however (and always = the=20 same one), the handle doesn't show up. When you to type in a cell, the=20 warning box still appears saying that you have to select data from the = list,=20 but the handle never appears, making selection impossible.=20 Thinking the workbook was corrupt, I tried copying the whole sheet into = a=20 new workbook, and the validation in the problem column did work for a=20 while, but now it's gone again. The other two validated columns continue = to=20 work fine. Help! Is my file just hopelessly corrupt? I'm running this on Mac OSX-- might that be connected to the instability? Any ideas would be much=20 appreciated. |
#2
![]() |
|||
|
|||
![]()
My dear Watson,
Tell us exactly what the Data - Validations settings are in one of the errant cells are. Look in all three Data Validation tabs. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Watson" wrote in message ... Hi-- I have three columns which have data validation list boxes attached, so that when you click on a cell a little handle appears and you select a name from the list box that appears. In one of the columns, however (and always the same one), the handle doesn't show up. When you to type in a cell, the warning box still appears saying that you have to select data from the list, but the handle never appears, making selection impossible. Thinking the workbook was corrupt, I tried copying the whole sheet into a new workbook, and the validation in the problem column did work for a while, but now it's gone again. The other two validated columns continue to work fine. Help! Is my file just hopelessly corrupt? I'm running this on Mac OSX-- might that be connected to the instability? Any ideas would be much appreciated. |
#3
![]() |
|||
|
|||
![]()
I see you got the Holmes reference. Sorry about the delay--I had to =
leave=20 the office for the day. The settings are=20 as follows: ALLOW: List DATA: between SOURCE: =3D$AT$13:$AT$17 (These cells contain the items that should=20 appear on the list.) IGNORE BLANK is checked IN-CELL DROPDOWN is checked SHOW INPUT MESSAGE is checked (but there is no message) SHOW ERROR ALERT is checked TITLE is Error Alert STYLE is stop ERROR MESSAGE (I won't bore you with the text--it's about 110 = characters) That's it--except for the source cells and error text, the settiings are = the=20 same as for the others validations that work. Sigh. Any ideas? -----Original Message----- My dear Watson, Tell us exactly what the Data - Validations settings are in one of the=20 errant cells are. Look in all three Data Validation tabs. --=20 Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Watson" wrote in message=20 ... Hi-- I have three columns which have data validation list boxes attached, so = that when you click on a cell a little handle appears and you select a name = from the list box that appears. In one of the columns, however (and always = the same one), the handle doesn't show up. When you to type in a cell, the warning box still appears saying that you have to select data from the = list, but the handle never appears, making selection impossible. Thinking the workbook was corrupt, I tried copying the whole sheet into = a new workbook, and the validation in the problem column did work for a while, but now it's gone again. The other two validated columns = continue=20 to work fine. Help! Is my file just hopelessly corrupt? I'm running this on Mac = OSX-- might that be connected to the instability? Any ideas would be much appreciated.=20 . |
#4
![]() |
|||
|
|||
![]()
Watson,
If Allow is set to List, then Between should be grayed out. You said it's set to "between." If it's not grayed out, something is broken. "I'll take 'Things that don't work for $100, Alex.'" I suppose you could deselect Show Input Message, since there is none. That might work as well as standing up and turning around three times. Does this workbook use User-defined Functions (UDF's), by any chance (macros that return a value in a cell)? Pressing Alt-DownArrow brings up the dropdown, same as clicking the (missing) button. Try that on an errant cell. Other than that, I don't have any suggestions. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Watson" wrote in message ... I see you got the Holmes reference. Sorry about the delay--I had to leave the office for the day. The settings are as follows: ALLOW: List DATA: between SOURCE: =$AT$13:$AT$17 (These cells contain the items that should appear on the list.) IGNORE BLANK is checked IN-CELL DROPDOWN is checked SHOW INPUT MESSAGE is checked (but there is no message) SHOW ERROR ALERT is checked TITLE is Error Alert STYLE is stop ERROR MESSAGE (I won't bore you with the text--it's about 110 characters) That's it--except for the source cells and error text, the settiings are the same as for the others validations that work. Sigh. Any ideas? -----Original Message----- My dear Watson, Tell us exactly what the Data - Validations settings are in one of the errant cells are. Look in all three Data Validation tabs. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Watson" wrote in message ... Hi-- I have three columns which have data validation list boxes attached, so that when you click on a cell a little handle appears and you select a name from the list box that appears. In one of the columns, however (and always the same one), the handle doesn't show up. When you to type in a cell, the warning box still appears saying that you have to select data from the list, but the handle never appears, making selection impossible. Thinking the workbook was corrupt, I tried copying the whole sheet into a new workbook, and the validation in the problem column did work for a while, but now it's gone again. The other two validated columns continue to work fine. Help! Is my file just hopelessly corrupt? I'm running this on Mac OSX-- might that be connected to the instability? Any ideas would be much appreciated. . |
#5
![]() |
|||
|
|||
![]()
Do you have "frozen panes" and are running Excel 97 - the dropdown will not
work - remove the panes and try again. -- Regards, Martin "Earl Kiosterud" wrote: Watson, If Allow is set to List, then Between should be grayed out. You said it's set to "between." If it's not grayed out, something is broken. "I'll take 'Things that don't work for $100, Alex.'" I suppose you could deselect Show Input Message, since there is none. That might work as well as standing up and turning around three times. Does this workbook use User-defined Functions (UDF's), by any chance (macros that return a value in a cell)? Pressing Alt-DownArrow brings up the dropdown, same as clicking the (missing) button. Try that on an errant cell. Other than that, I don't have any suggestions. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Watson" wrote in message ... I see you got the Holmes reference. Sorry about the delay--I had to leave the office for the day. The settings are as follows: ALLOW: List DATA: between SOURCE: =$AT$13:$AT$17 (These cells contain the items that should appear on the list.) IGNORE BLANK is checked IN-CELL DROPDOWN is checked SHOW INPUT MESSAGE is checked (but there is no message) SHOW ERROR ALERT is checked TITLE is Error Alert STYLE is stop ERROR MESSAGE (I won't bore you with the text--it's about 110 characters) That's it--except for the source cells and error text, the settiings are the same as for the others validations that work. Sigh. Any ideas? -----Original Message----- My dear Watson, Tell us exactly what the Data - Validations settings are in one of the errant cells are. Look in all three Data Validation tabs. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Watson" wrote in message ... Hi-- I have three columns which have data validation list boxes attached, so that when you click on a cell a little handle appears and you select a name from the list box that appears. In one of the columns, however (and always the same one), the handle doesn't show up. When you to type in a cell, the warning box still appears saying that you have to select data from the list, but the handle never appears, making selection impossible. Thinking the workbook was corrupt, I tried copying the whole sheet into a new workbook, and the validation in the problem column did work for a while, but now it's gone again. The other two validated columns continue to work fine. Help! Is my file just hopelessly corrupt? I'm running this on Mac OSX-- might that be connected to the instability? Any ideas would be much appreciated. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
Auto scroll down data validation list | Excel Discussion (Misc queries) | |||
Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions | |||
Data Validation List =Name | Excel Discussion (Misc queries) | |||
Data Validation list selection question | Excel Worksheet Functions |