+ Reply to Thread
Results 1 to 11 of 11

Option button linked cells

Hybrid View

  1. #1
    Registered User
    Join Date
    10-15-2014
    Location
    Portsmouth
    MS-Off Ver
    2010
    Posts
    6

    Re: Option button linked cells

    Thanks for that

    The code I posted is used to create new rows and copy formulas. It doesn't necessarily need to be there.

    What I'm trying to achieve is that a user will be able to insert a new row with a new set of option buttons that are grouped separately from the existing ones with there own set of linked cells.

    The reason I was using the code above was because I had a friend who said he could adapt it to do what I wanted, he couldn't.

    I only have one worksheet so there is no need to replicate it across sheets, and even the function to add more than one row at once isn't essential. The most important feature is the ability to operate a new set of option buttons independently with linked cells for each row that's created.

    Have attached the Spreadsheet for reference.

    Sorry about not using code tags, will do in future
    Attached Files Attached Files

+ 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. Disable cells contingent on an option button
    By jghender in forum Excel General
    Replies: 0
    Last Post: 12-27-2012, 06:10 PM
  2. Option Button that shows/hide certain cells
    By DoubLeA in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 03:31 PM
  3. Radio Button Groups linked to cells for counting values
    By kathyb10 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-31-2011, 06:35 PM
  4. [SOLVED] using option button to highlight cells
    By Carl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-05-2006, 01:55 PM
  5. Need Help With Linked Option Button
    By Bd_Blues in forum Excel General
    Replies: 0
    Last Post: 02-01-2005, 08:39 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