ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Rest Option Buttons (https://www.excelbanter.com/excel-discussion-misc-queries/130280-rest-option-buttons.html)

Luke

Rest Option Buttons
 
Hi,

I have added a Reset button (Command Button) to a form I have made. The
button simply clears all the cells where data can be entered. In the form I
also have three option buttons A B and C. I cant wok out how to get the
option buttons to rest to A by using the Rest button.

Many thanks,

Luke


Bob Phillips

Rest Option Buttons
 
Me.OptionButton1.Value = True


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Luke" wrote in message
...
Hi,

I have added a Reset button (Command Button) to a form I have made. The
button simply clears all the cells where data can be entered. In the
form I
also have three option buttons A B and C. I can't wok out how to get the
option buttons to rest to A by using the Rest button.

Many thanks,

Luke




Luke

Rest Option Buttons
 
Great, thanks Bob.

"Bob Phillips" wrote:

Me.OptionButton1.Value = True


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Luke" wrote in message
...
Hi,

I have added a Reset button (Command Button) to a form I have made. The
button simply clears all the cells where data can be entered. In the
form I
also have three option buttons A B and C. I can't wok out how to get the
option buttons to rest to A by using the Rest button.

Many thanks,

Luke






All times are GMT +1. The time now is 02:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com