+ Reply to Thread
Results 1 to 2 of 2

I need to delete a cell value with VBA in excel with radio button

  1. #1
    Registered User
    Join Date
    10-15-2014
    Location
    india
    MS-Off Ver
    MS office 2013
    Posts
    6

    I need to delete a cell value with VBA in excel with radio button

    Hi all,
    i am new to vba in excel,

    I've a radio button linked with cell A1, (if one radio option selected then value of A1 will be "Y" and if second radio button selected then value of A1 will be "N")

    If value of A1 is "N" then it enables list in Cell B1 but if Value of A1 is "Y" then value of B1 needs to be deleted or blank cell.

    How can i code this in vba ?

    Please help.

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: I need to delete a cell value with VBA in excel with radio button

    How is the list being created if A1 is N?
    The following will delete B1 if A1 is Y. Put it in a Worksheet module
    Please Login or Register  to view this content.
    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 to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Radio Button to toggle YES or NO based on a cell value
    By egrospe17 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-10-2016, 11:22 PM
  2. [SOLVED] Radio Button Output for Cell Selection
    By dblcrona in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-27-2014, 10:58 AM
  3. Excel VBA to select IE radio button
    By amike402 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-20-2014, 03:00 PM
  4. [SOLVED] How to activate a cell on clicking a radio button in Excel?
    By Scofield24 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-13-2013, 04:36 PM
  5. Pressing one radio button to select another radio button
    By raehippychick in forum Excel General
    Replies: 1
    Last Post: 09-13-2007, 11:30 PM
  6. Radio Button to discount value in cell
    By robhargreaves in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-11-2007, 04:10 PM
  7. [SOLVED] How do I insert radio button to sum a cell when clicked
    By Joe D. in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-06-2006, 05:00 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