Results 1 to 5 of 5

Userform Option (Radial) Button - Retain Last choice

Threaded View

  1. #1
    Registered User
    Join Date
    08-30-2012
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2010
    Posts
    83

    Userform Option (Radial) Button - Retain Last choice

    Hi there,
    I am using Option (or if you prefer, Radial) buttons within a Userform.

    To simplify the problem, let's say that there are two option buttons - Male or Female. The User selects "Male", fills out various other pieces of information and then closes down the Userform.
    The next time the User opens the Userform, I want their choice to be remembered so that "Male" is selected by default.
    Should the User change their mind at some point in the future and change the option to "Female" and then close the Userform, it will be defaulted to "Female" the next time it is opened.

    Hopefully that illustrates my objective..

    My question is, am I able to capture and alter the default choice of Options, without referencing a cell somewhere within the workbook?

    Thanks for Reading the post. Look forwards to finding out what Options are available to me!
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 07-15-2017, 09:54 AM
  2. UserForm option button bug?
    By aarona in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2017, 04:03 AM
  3. [SOLVED] userform option button
    By adamheon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-26-2016, 09:28 AM
  4. Checkbox radial button - very new here
    By tnursall in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2013, 01:27 AM
  5. Userform option button help
    By mecharissa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-01-2012, 04:48 AM
  6. Replies: 2
    Last Post: 07-10-2012, 04:37 PM
  7. Userform Option Button to Show/Hide Another Option Button on same Userform
    By R_S_6 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-26-2010, 09:44 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1