+ Reply to Thread
Results 1 to 5 of 5

i want it so when a optionbox = true it puts yes into a cell of my workbook

  1. 01-29-2015, 10:14 AM #1
    Jenkins27
    Jenkins27 is offline
    Forum Contributor
    Join Date
    01-27-2015
    Location
    New hampshire
    MS-Off Ver
    excel 2013
    Posts
    143

    i want it so when a optionbox = true it puts yes into a cell of my workbook

    i have this code and i cannot get it so when my option button named "yesbox" = true it puts yes as a value in the cell.. any ideas?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 01-29-2015, 10:41 AM #2
    Jenkins27
    Jenkins27 is offline
    Forum Contributor
    Join Date
    01-27-2015
    Location
    New hampshire
    MS-Off Ver
    excel 2013
    Posts
    143

    Re: i want it so when a optionbox = true it puts yes into a cell of my workbook

    does anyone have any idea?
    Reply With QuoteRegister To Reply
  3. 01-29-2015, 10:43 AM #3
    gmr4evr1
    gmr4evr1 is offline
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: i want it so when a optionbox = true it puts yes into a cell of my workbook

    Put quotes around "true" and "yes" and see if that works
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom
    Reply With QuoteRegister To Reply
  4. 01-29-2015, 10:45 AM #4
    Jenkins27
    Jenkins27 is offline
    Forum Contributor
    Join Date
    01-27-2015
    Location
    New hampshire
    MS-Off Ver
    excel 2013
    Posts
    143

    Re: i want it so when a optionbox = true it puts yes into a cell of my workbook

    haha that you that was easy!
    Reply With QuoteRegister To Reply
  5. 01-29-2015, 10:46 AM #5
    gmr4evr1
    gmr4evr1 is offline
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: i want it so when a optionbox = true it puts yes into a cell of my workbook

    No problem
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Can any of you make a macro that parses date & time from one cell, puts in another cell ?
    By chrisd2000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-02-2014, 07:10 PM
  2. Is creating a hyperlink that puts information into a cell possible?
    By Kapi187 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-06-2013, 02:46 PM
  3. [SOLVED] Macro no longer puts formula in cell...?
    By fourmurphys in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-24-2013, 03:48 PM
  4. macro that puts in borders on any cell that is not empty
    By mash100 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-18-2012, 03:45 PM
  5. IN EXCEL I HAVE A LIST I TRY SORT ASENDING BUT IT PUTS TRUE AFTER.
    By DISCO DAVE in forum Excel General
    Replies: 2
    Last Post: 04-15-2005, 02:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1