+ Reply to Thread
Results 1 to 2 of 2

How controls work?

  1. #1
    Forum Contributor
    Join Date
    07-13-2015
    Location
    Poland
    MS-Off Ver
    MS Office 365
    Posts
    174

    How controls work?

    Hi,

    I've one question regarding excel inserting form or activeX controls. I've learned basics of VBA and till now been using only buttons and combo boxes. I wonder if others (for example option button) are normally used only inside forms or like afore mentioned work inside worksheet being not matched with any cell or can I also locate it accurately in specific cell on the sheet and use it in conjunction with vba to row visibility sterring.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: How controls work?

    Checkboxes can be linked to cells as these codes show.

    I cannot paste a spreadsheet.

    So post this code into a new work book and run each in turn.




    Please Login or Register  to view this content.
    Last edited by mehmetcik; 02-20-2016 at 08:01 AM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ 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. Controls don't work
    By jpskypilot in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-22-2015, 05:41 PM
  2. Form Controls / Active X controls to record and log information in a seperate sheet
    By marcbarnett in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-09-2014, 05:00 AM
  3. Strange: "For Each Ctrl In UserForm1.Controls" does not work
    By Xenova in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-01-2012, 03:07 AM
  4. Replies: 1
    Last Post: 04-20-2009, 03:39 AM
  5. Moved Userform Controls Don't Work
    By msleger in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-27-2008, 04:55 PM
  6. Multipage: [Me.Controls("Page" & i).Name] does not work
    By Zurn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-24-2006, 04:07 AM
  7. [SOLVED] Format decimal controls do not work
    By jimcrowl in forum Excel General
    Replies: 2
    Last Post: 01-07-2005, 06:06 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