ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data validation list, combobox (https://www.excelbanter.com/excel-discussion-misc-queries/261083-data-validation-list-combobox.html)

cousinexcel

Data validation list, combobox
 
Hi,
I had asked for a help against limitations of data validation list.
Thanks to Master Mike H., he had suggested
http://www.contextures.com/xlDataVal14.html
site.
Yes, this solution does exactly what need. But there is one problem.
I should not use aroows when I want to simply move the cursor.
It says "Press Tab or Enter to move to the next cell."
Because it understands for example the down arrow as changing to next value
from the data list. This is not easy to adapt after 25 years habbit of
walking around with arrows on the sheet. And also it is dangererous because I
may change a value unaawaresly.
Thanks and regards,
Cousin Excel


All times are GMT +1. The time now is 11:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com