+ Reply to Thread
Results 1 to 2 of 2

OptionButton Macro not functionning correctly

Hybrid View

  1. #1
    Registered User
    Join Date
    08-22-2011
    Location
    Laval quebec
    MS-Off Ver
    MS 365
    Posts
    99

    OptionButton Macro not functionning correctly

    Hi team,


    This should be an easy one but for some reason part of my macro is not functionning ONLY on windows XP machines..When I try on windows 7 everything is ok..

    So basically the bellow code is supposed to take the value of my optionbutton (True or False) in a UserForm and if the value is true then it puts an X on tab Quality Grid
    range G22..Why isn't this working on windows xp machines? Not giving me any errors ..the X just doesn't show after I submit form.


    
    Sub Extract()
    
    Dim iRow As Long
    Dim Ws As Worksheet
    Dim QG As Worksheet
    Set Ws = Worksheets("Evaluation Tracker")
    Set QG = Worksheets("Quality Grid")
    
    
    
    If Me.OptionButton15.Value = "True" Then 'OptionButtons 3 Year Term
    qa.Range("G22") = "X"
    
    End IF
    End Sub

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,963

    Re: OptionButton Macro not functionning correctly

    Set QG = Worksheets("Quality Grid")
    qa.Range("G22") = "X"
    Ben Van Johnson

+ 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. [SOLVED] Macro to change optionbutton properties permanently
    By HugoRibeiro in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-03-2013, 09:54 AM
  2. [SOLVED] Data Pull-up Macro not functionning correctly
    By djsouljah in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-29-2012, 08:11 PM
  3. Macro to select/tick certain ActiveX OptionButton (radio button)
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2011, 08:40 AM
  4. How to change OptionButton 'BackColor' using Macro
    By rmtschanz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2009, 05:49 AM
  5. Macro not working correctly
    By Colin Vicary in forum Excel General
    Replies: 3
    Last Post: 02-21-2007, 04:48 PM

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