#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 142
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,726
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 142
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
stuck on option buttons excel_stuck Excel Worksheet Functions 2 July 10th 06 11:13 AM
Want to get user selections from a message box using option buttons Walt Excel Discussion (Misc queries) 1 November 4th 05 03:04 AM
Excel Option Buttons Mar Excel Discussion (Misc queries) 2 November 3rd 05 05:13 PM
Option Buttons Ashman Excel Discussion (Misc queries) 2 July 10th 05 08:24 PM
grouping of option buttons mapi62 Excel Discussion (Misc queries) 0 February 22nd 05 12:19 PM


All times are GMT +1. The time now is 07:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"