christchaaya
Board Regular
- Joined
- Apr 5, 2013
- Messages
- 86
Hello 
I know how to let the user add items to a data validation list but in this case i need to do it to a dependent list and i donnow how to change the code :S
Normally str should get the list name and the code would run perfectly but the problem in this case is that "Target.Validation.Formula1" is "=INDIRECT($B$2)". do you have any idea how can i fix this ?
Thank you :D
I know how to let the user add items to a data validation list but in this case i need to do it to a dependent list and i donnow how to change the code :S
Code:
str = Target.Validation.Formula1
str = Right(str, Len(str) - 1)Normally str should get the list name and the code would run perfectly but the problem in this case is that "Target.Validation.Formula1" is "=INDIRECT($B$2)". do you have any idea how can i fix this ?
Thank you :D
