Forum Discussion
Solved
Set the value of a cell within a range and change it automatically
Hello to everyone! I have seen that you can set a data validation for a cell, so if you want the value of that cell to be within a range, an error message would appear. What I want is to set a v...
Maybe something like this dynamic dropdown will work. It will list out all of the numbers between 1 and the Maximum that you specify. See attached .xlsx file for an example.
It uses this data validation formula: =OFFSET($E$1,0,0,B1,1)
You can just use a short code snippet to accomplish your end goal (see attached .xlsm file):
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$1" Then
Range("H1") = Target.Value
End If
End Sub
That is what I was looking for!
I find that hard to use, as I want to do that with a lot of elements, but I'm gonna try it.
Thank you so much!