View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Preserve Option Buttun Selection

You could store the value in a public variable dimmed in a General module.

If you have lots of these and want to save the values even when the user closes
and reopens the workbook, you could save them in a worksheet (hidden???).

wrote:

I have 4 Option Buttons in a Frame on a Form.
This form will be called by user a number of times, in one application
session.
When the form is called for the 1st time, button 1 should be the
default.
With subsequent calls, the deafult button should be whatever the user
selected in the most recent call.
What is the best practice to implement it?

Thanks


--

Dave Peterson