+ Reply to Thread
Results 1 to 2 of 2

Soring Userform Radio value to cell issue

  1. #1
    Forum Contributor NewYears1978's Avatar
    Join Date
    03-15-2010
    Location
    Forney, TX
    MS-Off Ver
    Excel 2016
    Posts
    962

    Soring Userform Radio value to cell issue

    Hey all!

    I use this type code all the time without issue. I have named ranges set, in this case varBrowserNumber which applies to a cell in one of my sheets.
    I am saving a number to the cell based on radio selection like below:

    Worksheets("Variables").Range("varBrowserNumber").Value = "1"

    For some reason this is saving a true false value (boolean) instead of the number 1. I tried var("1") and other methods but I cannot get it to work. Any pointers?

    Thanks in advance!

    Edit:
    Here's some more context, if I paste the above directly in the immediate window, it works. But in my overall code (below) it doesn't:

    Please Login or Register  to view this content.
    Last edited by NewYears1978; 04-13-2023 at 04:23 PM.

  2. #2
    Forum Contributor NewYears1978's Avatar
    Join Date
    03-15-2010
    Location
    Forney, TX
    MS-Off Ver
    Excel 2016
    Posts
    962

    Re: Soring Userform Radio value to cell issue

    Wow I am dumb. I had the radios and the checkbox tied to the same named range so my choice was overwriting itself. Wooops!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 04-11-2021, 12:42 PM
  2. Issue with radio buttons
    By jancliff in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-25-2018, 05:51 PM
  3. [SOLVED] Radio Button reference cell issue
    By gan_xl in forum Excel General
    Replies: 4
    Last Post: 10-03-2018, 07:13 AM
  4. Issue with Private Radio buttons
    By klab16 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2016, 05:37 PM
  5. [SOLVED] Soring data and keeping reference cells
    By Car7os in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-19-2013, 10:17 AM
  6. [SOLVED] Ordinal Ranking or places, allowing ties after soring scores
    By JMacrow in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-10-2012, 02:07 PM
  7. Userform Radio Buttons
    By neodjandre in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2007, 09:49 AM

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