The Multiple drop down option is not working in some of the machines. All the machines are laoded with excel 2007. Can somebody help me to understand what could be the reason for this error?...
Thanks in advance,
Tonis
The Multiple drop down option is not working in some of the machines. All the machines are laoded with excel 2007. Can somebody help me to understand what could be the reason for this error?...
Thanks in advance,
Tonis
Hi,
We need to know a little more. Specifically what you actually mean by a multiple drop down. Is this a cell with data validation, an Activex control, a Forms control or what?
Better still upload the workbook.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Hi Richard,
Thanks for message.
The file is created with data validation.
What im trying to do is crate a dopdown list and a dependent dropdown list based on the first dropdown list. This is working perfectly in some of the machines. But in some of the machines the dependent dropdown list is not working.
Kindly let me know if you need any further details.
Thanks in advance,
Tonis
Hi,
Any chance you could upload the workbook?
Is this what you are talking about?
Sheet 1 "SELECT" - If in cell B3 you make your selection, then C3 will only show the parts available for that chosen in B3 (the first Drop-down)
Anyway, have a look:
DATA VALIDATION-Lists.xlsx
Hi Richard,
This is exactly what im looking....Thank you very much...
I will check the same in other machines and revert.
Once again thank you...
Tonis
Hi tonisjoseph,
I'll think you'll find I submitted the spreadsheet but whatever that doesn't really matter, just as long as you have the solution you are looking for.
If you're happy please mark threat as "SOLVED" and if you wouldn't mind click on my "Add Reputation".
Cheers,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks