+ Reply to Thread
Results 1 to 6 of 6

Problem with option button and macros

  1. #1
    Registered User
    Join Date
    10-06-2011
    Location
    Lisbon
    MS-Off Ver
    Excel 2003
    Posts
    3

    Problem with option button and macros

    Hi all,

    I have one issue i canīt resolve. I have 4 option buttons and the check in two options buttons corresponds to one value, if i check another option button the value change too. If i change the value (correspond of two option buttons), i want to change the options button check, but this doesnīt happen.

    Its necessary to do some changes in macro code?

    If you see the attached file you can see what i said.

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Problem with option button and macros

    You need to set the cell link for your "no" radio buttons, if you then change the value, the radio button witll change

  3. #3
    Registered User
    Join Date
    10-06-2011
    Location
    Lisbon
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Problem with option button and macros

    Quote Originally Posted by Kyle123 View Post
    You need to set the cell link for your "no" radio buttons, if you then change the value, the radio button witll change
    Hi kyle,

    Thanks for your response.

    If you dont cell link its another way to put the radio buttons working? I think not but its just a question and i explain why. This is a part of and official document and im using some 3rd part software to right cell in excel (at this case). Its not supose to change anything (because its password protected).

    Thanks in advance.

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Problem with option button and macros

    Hi

    Not that I can think of

  5. #5
    Registered User
    Join Date
    10-06-2011
    Location
    Lisbon
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Problem with option button and macros

    Quote Originally Posted by Kyle123 View Post
    Hi

    Not that I can think of
    Thanks Kyle!

  6. #6
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Problem with option button and macros

    Hello dguilherme,

    please can you either give me the password of your VBA project or unprotect your VBA project and upload your Workbook again.

    Thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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