Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option button memory
Is it possible to remove the last action button in userform option button.
What I have is if you go to a worksheet from userform then recall userform you can not go back again without going somewhere else first. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option button memory
You have two possibilities I can see right off. Put a CANCEL button on your
UserForm that will Unload it. Or in your UserForm Initialize code, set the OptionButtons to False to re-set them. Mike F "Curt" wrote in message ... Is it possible to remove the last action button in userform option button. What I have is if you go to a worksheet from userform then recall userform you can not go back again without going somewhere else first. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option button memory
Thanks much optionbutton1.value=false worked in each option buttom. Thanks
for putting me on right track Thanks "Mike Fogleman" wrote: You have two possibilities I can see right off. Put a CANCEL button on your UserForm that will Unload it. Or in your UserForm Initialize code, set the OptionButtons to False to re-set them. Mike F "Curt" wrote in message ... Is it possible to remove the last action button in userform option button. What I have is if you go to a worksheet from userform then recall userform you can not go back again without going somewhere else first. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
Getting value of Option button | Excel Programming | |||
option button | Excel Discussion (Misc queries) | |||
Option Button Value | Excel Programming | |||
Option Button | Excel Discussion (Misc queries) |