Hiya,
I have a spreadsheet, which users must complete by selecting a series of drop down boxes. (using dependant lists)
Depending on the choice i want to 'force' them to enter details into a comments section.
So for example, if they select 'ABC' or 'XYZ' from the drop down box then they need to have an entry in cell A6.
Can this be achieved simply with a formula of data validation? or is this delving into tricky marco areas?
Ta
Luca
Realistically VBA.
You could use Conditional Formatting to flag that A6 requires entry based on other selections but that's about it
If you opt for VBA dependency you then to consider reality of Macros not being enabled and then building in processes to ensure that doesn't happen etc...
In short, you need to decide whether it's worth the (additional) effort
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks