+ Reply to Thread
Results 1 to 3 of 3

Code to hide cells when option button chosen error

  1. #1
    Registered User
    Join Date
    02-01-2013
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2010
    Posts
    32

    Code to hide cells when option button chosen error

    Hi

    I have an excel order form that I have created. It uses mainly radial buttons (not active x) where the customer can choose an option and the price is calculated based on their answer. However, there are some options that are only available if another certain option is chosen.

    For example "Option 1" has three possible choices. The first and second options affect the 8th option - rows 72 to 78 are to be hidden if the first two are chosen and they are to be visible if the 3rd choice in option 1 is chosen. Now everything was working perfectly until I placed all of the radio buttons. And now it has stopped working - I keep getting runtime errors.

    Can anyone help?
    Problem custom ordering file.xlsm
    Last edited by lindafinlay; 07-13-2014 at 11:50 PM. Reason: solved

  2. #2
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Code to hide cells when option button chosen error

    hi lindafinlay, it errors out due empty rows being hidden after row 83 till the end of the sheet, you may hide all those rows but only after row 86 and everything will work as expected

  3. #3
    Registered User
    Join Date
    02-01-2013
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2010
    Posts
    32

    Re: Code to hide cells when option button chosen error

    Great! Thanks

+ 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. Hide a picture button placed in all sheets using a option button (form control)
    By lagaranch in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-26-2012, 10:33 AM
  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. Test which Option Button is chosen
    By djblois1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-19-2012, 02:49 PM
  4. Need VBA code to hide cells if radio button in another cell is chosen
    By sqearly in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-26-2011, 01:10 PM
  5. Userform Option Button to Show/Hide Another Option Button on same Userform
    By R_S_6 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-26-2010, 09:44 AM

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