Preserve Option Buttun Selection

  • Thread starter Thread starter onlyng
  • Start date Start date
O

onlyng

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
 
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???).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bizarre option button behavior 2
Code help needed for Option Buttons to control Subs 6
Output from Frames - multiple optionbutton groups 1
Access Create option group without using wizard? 2
application.activesheet, should I use it? 3
Fetch data from multiple .csv file paste into single sheet 5
Shortcut key to commandbutton 3
macro to select option button in option group 2

Back
Top