Hey all,
I'm have trouble creating a drop-down validation list. One of my four sheets in my workbook will not create a drop-down list when I try to do so in the validation properties for a cell. All the settings are correct: I chose "List", I entered a valid range, I checked "In-cell drop down"... but there is no drop-down! The validation works fine in the sense that I am prevented from entering an invalid entry in the cell... but I can't choose a valid one from a drop-down! Creating drop-down validation lists works just fine on other worksheets in the workbook - why won't it work on just this one worksheet?
This is rather urgent... it needs to be done today, and the sooner the better. If need be, I will increase the points - this project must be finished today!
Thanks,
PtG
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
#1 - i have tons of code in ThisWorkbook and Module1 and another module (modCommon)... there are events in ThisWorkbook (Workbook_Open and Workbook_SheetSelectionCha
#2 - yes that works! but I have references to the worksheet in my code... I have the feeling that if I change the reference to the new sheet, I'll have the same problem... but i'll try it out.
more suggestions?
-PtG
I was wondering if you were triggering a sheet event or maybe even a class module that somehow disabled the data validation. What is your Workbook_SheetSelectionCha
When weird stuff happens (mainly excel crashing) I go for the sheet copy option, it works more times than not
No more ideas.
Cheers
Dave
The main front sheet allows the user to click in certain areas, triggering the macro to mark those areas with an X or unmark them. This also causes data in the problematic worksheet to change. I'm going to try working with my copy of the worksheet and re-referencing that... we'll see what happens.
Thanks so far!
-PtG
Business Accounts
Answer for Membership
by: brettdjPosted on 2003-08-29 at 09:09:25ID: 9249067
Hi PaultheGreat,
1) Do you have any sheet code events on this sheet (or any code at all for that matter)
2) If you make a copy of this sheet (right click tab and tick the copy checkbox) does it work on the copy ?
Cheers
Dave