Hi,
I have a data validation from a worksheet. I want the standard value op the list to be the last row of the sheet, it that possible?
Hi,
I have a data validation from a worksheet. I want the standard value op the list to be the last row of the sheet, it that possible?
Last edited by mdek; 02-01-2016 at 11:55 AM.
What does this mean ...
The last row on the sheet ... 1048576? Or the last entry in the Data Validation List?I want the standard value of the list to be the last row of the sheet
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Last entry
OK ... This works for Data Validation applied to Column A
It will return the last entry in the DV List to any cell in column A that has DV applied to it
Please Login or Register to view this content.
Dynamic Named Range on Sheet2:Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
Sheet2!A1:A7
HTML Code:
regards, TMS
Thank you, the data validation dropdown on sheet1 has to have standaard the last value but the user also must have the option to select a other value. I only get the last row. What is the meaning of the formula on sheet2? thanks in advance
It would help move things along if you uploaded a sample workbook.
The formula is a Dynamic Named Range referring to a Data Validation List.
Hi
I have uploaded a quick sample.
The last row / date from sheet1 i want as standard value is B1 sheet2.
It tried your code but some how im doing something wrong
If tried also a checkbox, if clicked then the user can change the dropdown otherwise the standard value with be taken. I cant get it to so in not clicked the dropdown is not selectable
Thanks
Last edited by mdek; 02-01-2016 at 05:44 AM.
See attached updated example.
Regards, TMS
Thanks, now i get it, i left my code in, so that was going wrong..
I have got a checkbox if the its unchecked then the dropdown is unselectable, the problem is that i cannot read the value of the unselectable dropdown
I have no idea what that means, sorry.I have got a checkbox if the its unchecked then the dropdown is unselectable, the problem is that i cannot read the value of the unselectable dropdown
However, the question you originally asked has been answered
YEp Thank you very much!
Hi,
i just can it about the formula, i want the use the same code for a other dv. sheet4 nd sheet14 are the vaules.
How do i do it with the formula?
You create a (Dynamic) Named Range to refer to the list, for example, nrList2, and then use that in the Data Validation ...Formula:Please Login or Register to view this content.
The code is designed to determine the Named Range and the range it refers to ... so, in theory, it should work for the second list. If the DV is on another sheet, you would need to replicate the Selection Change event handler
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks