I am looking at the Validation List Choice code posted on Dec. 17th 2008 by xlHammer, I am confused regarding the "If target.Address = "$B$3" statement. What is confusing me is the "$B$3" and the explantion that is given. Could you please give me a clear explantion regarding this. Thanks for the help
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Validation Lists
- Thread starter cwv1949
- Start date
MrKowz
Well-known Member
- Joined
- Jun 30, 2008
- Messages
- 6,653
- Office Version
- 365
- 2016
- Platform
- Windows
Welcome to the forums!
Would you be able to provide the code (or a link to the post), so we can provide a better explanation?
To answer your immediate question, however. target.Address returns the cell address of whatever the "target" cell is. If the target is A1, then target.Address returns the string "$A$1". If the target is B3, then target.Address returns the string "$B$3".
Would you be able to provide the code (or a link to the post), so we can provide a better explanation?
To answer your immediate question, however. target.Address returns the cell address of whatever the "target" cell is. If the target is A1, then target.Address returns the string "$A$1". If the target is B3, then target.Address returns the string "$B$3".
Upvote
0
Similar threads
- Question
