Results 1 to 13 of 13

Updating Checkbox - Run-time Error 91 - Object variable or With block variable not set

Threaded View

nikadon Updating Checkbox - Run-time... 12-27-2019, 11:14 AM
6StringJazzer Re: Updating Checkbox -... 12-27-2019, 11:31 AM
nikadon Re: Updating Checkbox -... 12-27-2019, 12:01 PM
torachan Re: Updating Checkbox -... 12-27-2019, 11:36 AM
nikadon Re: Updating Checkbox -... 12-27-2019, 12:08 PM
6StringJazzer Re: Updating Checkbox -... 12-27-2019, 11:37 AM
nikadon Re: Updating Checkbox -... 12-27-2019, 01:15 PM
6StringJazzer Re: Updating Checkbox -... 12-27-2019, 04:07 PM
nikadon Re: Updating Checkbox -... 12-28-2019, 12:29 PM
torachan Re: Updating Checkbox -... 12-27-2019, 05:39 PM
6StringJazzer Re: Updating Checkbox -... 12-27-2019, 07:48 PM
torachan Re: Updating Checkbox -... 12-28-2019, 04:22 AM
6StringJazzer Re: Updating Checkbox -... 12-28-2019, 08:55 AM
  1. #8
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,822

    Re: Updating Checkbox - Run-time Error 91 - Object variable or With block variable not set

    You would create three option buttons for each row. If you use Forms controls you have to put each group of three into a Group Box. If you use ActiveX then you would set the Group property to be the same for all three.

    Frankly I think using this many controls is a error-prone to create and maintain, even though it's kind of cool for the user.

    Here is an example where you just click directly on the cell itself. I did it down to row 39. The corresponding code is in the sheet module.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Run time error '91' object variable/with block variable not set when using Find
    By lynnsong986 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-24-2019, 08:33 AM
  2. [SOLVED] Run-time error '91': Object variable or With block variable not set when closing userform
    By bishoposiris in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2016, 08:59 AM
  3. Replies: 0
    Last Post: 04-16-2013, 07:15 AM
  4. Replies: 6
    Last Post: 12-21-2012, 08:03 AM
  5. Replies: 1
    Last Post: 09-25-2012, 08:03 PM
  6. [SOLVED] Intermittent Run-time Error 91: Object Variable or With Block variable not set
    By fraanchtoast in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-29-2012, 10:11 AM
  7. Run Time Error 91, Object Variable or With Block Variable not set
    By undergraduate in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-12-2011, 02:08 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