Hello,
In my userform I have checkbox1. In textbox1 I am trying to set its control source based on the value of checkbox1.
I have entered into the control source of textbox1 the following code (which does not work):
=iif([checkbox1]=True,A1,A2)
Any ideas how I can get this to work?
Thanks
Try =IIF(CheckBox1.Value, Range("A1"), Range("A2")).Address(,,,true)
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks