deselect my check box and all the executions I have done will go back to it original

[achill3s]

How do i - when I deselect my option box and all the executions I have done will go back to it original format ? ( instead of the "you unchecked the box")

Please Login or Register  to view this content.

[Mordred]

What do you mean by executions?

[achill3s]

Basically I want my cell P19 to clear when I uncheck my option box.

[Mordred]

Alright, try

Please Login or Register  to view this content.

[Mordred]

Or try the following with your copy/paste changed and most of the .Select statements removed.

Please Login or Register  to view this content.

[achill3s]

hmm doesnt work. My content in P19 is still here.

[Mordred]

Can an option button be deselected? How are you doing that?

EDIT: I know that an option button can be deselected when another option button is selected but I can't see how a single option button can be deselected.

[achill3s]

I have a row of option boxes. So I was hoping when I select the optionbutton2, the optionbutton1 content in P19 will disappear.

[Mordred]

Try

Please Login or Register  to view this content.

[royUK]

Use a CheckBox

Please Login or Register  to view this content.

[achill3s]

It worked !!!

I have another problem... why cant I copy and and paste it to another worksheet ?

Please Login or Register  to view this content.

[achill3s]

There will be a "Run-time error '1004': Select method of Range class failed" popping up

[royUK]

You've totally ignored the fact that everyone has tried to show you how to write code with Selecting.

[royUK]

I'm afraid your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).