Solved: Data Validation in xl 2000

Quote:

---

Originally Posted by xld

Here is a version using range names

---

Hi Bob,

My apologies for not replying sooner. I just got a new computer yesterday, so true to my avatar, I have upgraded my computer to a Vista and am now an Excel 2007 user. From your previous posts, I know Excel07 has advantages (the IFERROR functions etc and the fact that analysis toolpak is built in), and not so great features (such as removing the F4 key and the Ribbon format). Should eb interesting to experiment with.

Thank you sincerely for your help with this problem. I am going to try it out on my Userform and will let you know if I have any queries.

regards,

2007 is an interseting journey (one way to put it). I must admit that I only use it when I have a job that needs it, otherwise I still use 2003.

As for Vista, my wife has it, but I have only ever used it on her laptop. With Windows 7 in beta now, I will be passing Vista by.

Did you get it sorted it mate?

Quote:

---

Originally Posted by xld

Did you get it sorted it mate?

---

Bob,

Thanks for your follow up. Thanks to your method, I did get it sorted :friends:.

I've had a few internet connection issues this weekend, so couldn't reply to you sooner.

BTW, Excel 2007 is good for beginners, but for those people that use Excel 2003 on a day to day basis, it is a bit tedious to figure out simple things like how to unhide sheets in it. I am still trying to get used to it, there must be some good stuff there. Do you know if the next generation of Office will revert back to the Excel 2003 menu structure from the Ribbon format?

As for you passing on Vista, it seems like a good idea to wait out for the Next Windows. I must admit though, it certainly is quite a pleasant looking operating System (for my simple home desktop use), and am finding that the main issue is the multiple "Continue" or "Close" Selections you have to keep clicking.

regards,

Glad it is all okay now.

2007 might be good for beginners, but my main objection is that MS seemed determined that they know best, that they could/should dictate to us how we should work. It is harder to push Excel as we could (easily) with 2003, it is slower to use, and is generally a less useful product. They seem to believe that all Office products are much of a muchness and should work the same - they aren't, I could easily live without Outlook, Powerpoint or Access, but not Excel (2003). Ally that to the fact that they still determined to push out VBA and drive Office programmability to .Net which is a lot tougher for the business types, and you have a misguided policy IMO. MS should stop being obsessed by prettying the product, and dictating how we work, and look to improve many of the functional improvements that are desperately required

Excel has become so ubiquitous because it did its basics well, but it was easily extendible so that the market could drive the way it deveopled, not some hidebound bureacratic corporation. If they destroy that, they are playing with fire, if OOO improves it will grab huge market share.

Similarly, Vista may be pretty, but that is not the (primary) aim of an OS. It should make life easy to get at the real stuff, networking, files, applications. Vista fails in that IMO, and it is huge, needing ever more hardware. Netbooks are starting to take real market share - MS be warned.