LinkBack URL
About LinkBacks
DertyLlama792 
I am looking for a way to have a cell default to a named cell if another cell has the answer "yes" and if the cell says "no" i want the user to be able to input any number. Any tricks out there that could solve my problem?
I am looking for a way to have a cell default to a named cell if another cell has the answer "yes" and if the cell says "no" i want the user to be able to input any number. Any tricks out there that could solve my problem?
Hi DertyLlama792,
Welcome to the forum.
I guess IF function will not suit here.. the only solution is VBA (macros). Thanks.
Are you fine with this?
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
Do you have any suggestions for functions that i could possibly use. I am familiar with VBA but more with writing loops and not necessarily data validation
Hi DirtyLlama792,
As you are familiar with VBA, try using below approach :-
Note: I have not tested it.
'put data validation as Yes, No in cell a1 If range("a1") = "No" Then k = InputBox("Please enter a value", "Input") Else k = "=data" 'where "data" is a defined name End If range("b1") = k
Regards,
DILIPandey
<click on below 'star' if this helps>
Thanks! Do you know if there is anyway to activate a macro when the "Yes" "No" cell has been changed?
Hi DertyLlama792,
Since you are familiar with VBA, you can use worksheet events like "selection change" or "change" ..
up to you
Regards,
DILIPandey
<click on below 'star' if this helps>
All set thanks!!
You are welcome..
Cheers
Regards,
DILIPandey
<click on below 'star' if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks