Hi I would like seek some assistance with my code. I cannot get the result I want using the If then else statement using checkbox.
Here is my code:
Please Login or Register to view this content.
Hi I would like seek some assistance with my code. I cannot get the result I want using the If then else statement using checkbox.
Here is my code:
Please Login or Register to view this content.
Last edited by 323100N; 03-14-2019 at 10:25 AM.
Are you getting a value from checkbox20
TryPlease Login or Register to view this content.
And you have no value for RowCounter after it is declared
Actually I want the value to go to specific cell (rowncounter 7) if the user Click the Checkbox it will show Pass else Fail. I keep on getting "Pass" value
Thanks!
Last edited by 323100N; 03-14-2019 at 10:24 AM.
I dont get it - you have declared Rowcounter as Long (a numeric value) so your desired range isbut you havent set a value for rowcounter as far as I can see. Correct me if I am just not seeing itPlease Login or Register to view this content.
Opps sorry I already updated the code i forgot this portion RowCounter = 0
Hi,
This works for me
Please Login or Register to view this content.
Click the * Add Reputation below to say thanks.
Probably typoPlease Login or Register to view this content.
It is not a typo.
This works
and this worksPlease Login or Register to view this content.
and this worksPlease Login or Register to view this content.
(at least in office 2016)Please Login or Register to view this content.
@ Dotchijack
Never knew that you could abbreviate to that extent
@ nigelog I don't like typing.
Thank you! It works great now
Glad to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks