+ Reply to Thread
Results 1 to 2 of 2

OptionButton Macro not functionning correctly

  1. #1
    Registered User
    Join Date
    08-22-2011
    Location
    Laval quebec
    MS-Off Ver
    Excel 2007
    Posts
    93

    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.


    Please Login or Register  to view this content.

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

    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