+ Reply to Thread
Results 1 to 5 of 5

Added Check Box Name doesn't change

  1. #1
    Registered User
    Join Date
    09-18-2019
    Location
    London, England
    MS-Off Ver
    MS Office Profesional Plus 2010
    Posts
    12

    Added Check Box Name doesn't change

    For anyone that can help,

    I want to add check boxes in column A and more specifically in Range(A8:A367). As I'm adding the check boxes I'm trying to rename them according to the row number. So for example in cell A8 I will have CBX_8, in cell A9 CBX_9 etc. Searching inside the forum I found a code which in a way is doing what is supposed to do but when I altered it to give me the names that I wanted, although it keeps adding the check boxes the name remains the same for all of them. Can someone help me and tell me what i'm doing wrong ?

    Please Login or Register  to view this content.
    The reason that I want to give to the check boxes those names is because afterwards I want by another code to check if the value in column c is "" and hide the checkbox if it is. This I'm planning to do with the below code which I found again in the forum.

    Please Login or Register  to view this content.
    I hope I'm not asking too much.
    Just for your information my knowledge in VBA is limited.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Added Check Box Name doesn't change

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Last edited by AlphaFrog; 10-01-2019 at 02:57 AM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,158

    Re: Added Check Box Name doesn't change

    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
    Alphafrog beat me to it....
    Last edited by sintek; 10-01-2019 at 02:59 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  4. #4
    Registered User
    Join Date
    09-18-2019
    Location
    London, England
    MS-Off Ver
    MS Office Profesional Plus 2010
    Posts
    12

    Re: Added Check Box Name doesn't change

    Really sometimes the solution is so obvious that my lack of knowledge makes it seem like nuclear physics.

    Thank you very much AlphaFrog. I really appreciate it.

  5. #5
    Registered User
    Join Date
    09-18-2019
    Location
    London, England
    MS-Off Ver
    MS Office Profesional Plus 2010
    Posts
    12

    Re: Added Check Box Name doesn't change

    Quote Originally Posted by sintek View Post
    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
    Alphafrog beat me to it....
    Thank you for willing to help as well. If you feel you have the energy I have another problem looking for solution for you .

+ 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. [SOLVED] Check if data was added, deleted on change within table
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2019, 09:08 AM
  2. [SOLVED] check to see if a person has already been added to the workbook
    By chriswrcg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-05-2018, 11:27 AM
  3. External refrences doesn't get added to =SUM?
    By horsefish01 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 07-09-2015, 10:56 AM
  4. How to check the template xlt has been added data and autorun a macro?
    By joslau in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-01-2014, 10:40 PM
  5. add a check box and have weight added when box is checked
    By jamiemchick in forum Excel General
    Replies: 6
    Last Post: 12-17-2010, 03:37 PM
  6. How to add a check box for each sheet added?
    By gshock in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-25-2008, 10:58 AM
  7. How to add check boxes as sheets are added?
    By gshock in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-24-2008, 03:50 PM

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