Thread
:
Preserve Option Buttun Selection
View Single Post
#
2
Posted to microsoft.public.excel.programming
Dave Peterson
external usenet poster
Posts: 35,218
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
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson