+ Reply to Thread
Results 1 to 14 of 14

Add ActiveX controls to toolbox

  1. #1
    Registered User
    Join Date
    08-20-2020
    Location
    Houston, Texas
    MS-Off Ver
    2016 Excel
    Posts
    16

    Add ActiveX controls to toolbox

    1. Bottom line, I want to have a control on an Excel UserForm which has the 'Linked Cell' capability of the ActiveX ComboBox. I don't see such on the Toolbox ComboBox, but I may be overlooking something. If so please let me know.

    2. I'm on Microsoft 365. My ToolBox doesn't have any ActiveX controls so I've tried adding them according to Microsoft. Tools>Choose Toolbox Item.....and I have to stop right there because the latter doesn't appear. I have References, Additional Controls (I've looked through this list and the one item with ActiveX didn't help), Macros, Options (nothing to help there), VBA Project Properties, and Digital Signature.

    Thoughts on both 1 and 2? Thanks!

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    18,605

    Re: Add ActiveX controls to toolbox

    LinkedCell is not supported for UserForm controls (I don't know why). You can get the same effect by creating VBA code for the Change event sub for the control, to update the cell whenever the control changes. If you need it to be two-way, you can also add a Worksheet_Change in the worksheet containing the linked cell, but you will need to put in oversight to prevent an infinite loop going back and forth between the control and the worksheet.

    Are you talking about the toolbox in the worksheet, or on a UserForm? It would help if you described what you want to achieve rather the method you want to use to achieve it.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    08-20-2020
    Location
    Houston, Texas
    MS-Off Ver
    2016 Excel
    Posts
    16

    Re: Add ActiveX controls to toolbox

    6StringJazzer,
    Yeah, using the Change event works. Thanks! I was talking about the toolbox on a UserForm. What I wanted to achieve was a cell which contained, on a character by character basis, the change in the ComboBox input. Sorry about not being clear. Thanks for the info and the quick response.

  4. #4
    Registered User
    Join Date
    08-20-2020
    Location
    Houston, Texas
    MS-Off Ver
    2016 Excel
    Posts
    16

    Re: Add ActiveX controls to toolbox

    Any thoughts on how to add the ActiveX controls to a UserForm toolbox? All documentation says they can be used on UserForms.

  5. #5
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    18,605

    Re: Add ActiveX controls to toolbox

    I have not done it but I'll look into it.

  6. #6
    Registered User
    Join Date
    08-20-2020
    Location
    Houston, Texas
    MS-Off Ver
    2016 Excel
    Posts
    16

    Re: Add ActiveX controls to toolbox

    Thanks for your help!

  7. #7
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    18,605

    Re: Add ActiveX controls to toolbox

    After having a second look I'm a little unclear as to what you are looking for. The controls in the UserForm toolbox are ActiveX. Do you mean how to add controls that are not there by default?

  8. #8
    Registered User
    Join Date
    08-20-2020
    Location
    Houston, Texas
    MS-Off Ver
    2016 Excel
    Posts
    16

    Re: Add ActiveX controls to toolbox

    Attachment 747328Attachment 747329

    Attachment 747328 is the toolbox I get when I add a control directly to an Excel Spreadsheet. 747329 is the one that I get when adding controls to a UserForm. There are no ActiveX controls in this toolbox. As stated before I've tried adding such but have not found a method to do so. Maybe there is another way to add the ActiveX controls to a UserForm. I tried directly adding them from the first attachment but it doesn't work. And yet documentation says that one can use ActiveX controls on a UserForm. So I'm puzzled. Thanks for pursuing this for me.
    Last edited by Habakkuk123; 09-11-2021 at 04:03 PM.

  9. #9
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    18,605

    Re: Add ActiveX controls to toolbox

    The controls you see when you open the toolbox in a UserForm are all ActiveX. There is no option for Forms controls in a UserForm, so the only thing it shows you are the ActiveX controls. Some options may be slightly different than what you see when you use ActiveX controls in a worksheet (liked the LinkedCell from earlier).

    What is it that you want to do that you can't do with the available controls?

  10. #10
    Registered User
    Join Date
    08-20-2020
    Location
    Houston, Texas
    MS-Off Ver
    2016 Excel
    Posts
    16

    Re: Add ActiveX controls to toolbox

    6StringJazzer,
    I appreciate your hanging in there with me. I'm either throughly confused or not explaining myself well, or both! So trying once more. What I'm trying to achieve is a ComboBox on a UserForm which has a linked cell property so that when the user enters a value in the ComboBox the entered value appears in the linked cell on a spreadsheet.

    Attached are four pics. On 747692 I have shown the controls available when I go to Developer>Insert. A blue line (#1) goes from the ActiveX ComboBox icon to the resultant control that is entered on the spreadsheet. A red line (#2) goes from the Form Controls ComboBox to the resultant control that is entered on the spreadsheet. The a right click on the latter control does not give properties but rather Format Control, which does have a 'Cell link' field, but since the control is on a spreadsheet and not a UserForm I haven't investigated it.

    On 747693 I have circled the LinkedCell field entry from the ActiveX ComboBox property list.

    On 747694 I show the control entered on a UserForm when clicking on the ComboBox icon in the Toolbox Controls. And 747695 shows the properties for this ComboBox. No Linked Cell entry appears.

    I have programmed the procedure that you suggested in message #2 above and it works. I'm just trying to find a simpler way.

    Truly appreciate your help! How does one give you stars or whatever the correct applause is?

    Attachment 747692Attachment 747693Attachment 747694Attachment 747695

  11. #11
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    6,309

    Re: Add ActiveX controls to toolbox

    ControlSource is the property you want for a combobox on a userform.
    Rory
    I drink, and I know things

  12. #12
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    18,605

    Re: Add ActiveX controls to toolbox

    Quote Originally Posted by Habakkuk123 View Post
    Attached are four pics.
    We have a hiccup on the forum when attaching images. What you did is supposed to work, but doesn't. To post an image, first click Go Advanced so you get a preview of your post. Then go back to the edit window and click the image button to insert your images.

    Truly appreciate your help! How does one give you stars or whatever the correct applause is?
    Nice of you to ask. If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.

  13. #13
    Registered User
    Join Date
    08-20-2020
    Location
    Houston, Texas
    MS-Off Ver
    2016 Excel
    Posts
    16

    Re: Add ActiveX controls to toolbox

    6StringJazzer,
    I appreciate your hanging in there with me. I'm either throughly confused or not explaining myself well, or both! So trying once more. What I'm trying to achieve is a ComboBox on a UserForm which has a linked cell property so that when the user enters a value in the ComboBox the entered value appears in the linked cell on a spreadsheet.

    Attached are four pics. On 747692 I have shown the controls available when I go to Developer>Insert. A blue line (#1) goes from the ActiveX ComboBox icon to the resultant control that is entered on the spreadsheet. A red line (#2) goes from the Form Controls ComboBox to the resultant control that is entered on the spreadsheet. The a right click on the latter control does not give properties but rather Format Control, which does have a 'Cell link' field, but since the control is on a spreadsheet and not a UserForm I haven't investigated it.

    On 747693 I have circled the LinkedCell field entry from the ActiveX ComboBox property list.

    On 747694 I show the control entered on a UserForm when clicking on the ComboBox icon in the Toolbox Controls. And 747695 shows the properties for this ComboBox. No Linked Cell entry appears.

    I have programmed the procedure that you suggested in message #2 above and it works. I'm just trying to find a simpler way.

    Truly appreciate your help! How does one give you stars or whatever the correct applause is?

    SS_ActiveX_ComboBox.pngSS_ActiveX_ComboBox_Properties.pngUserFormComboBoxProperties.pngUserFormComboBox.png

  14. #14
    Registered User
    Join Date
    08-20-2020
    Location
    Houston, Texas
    MS-Off Ver
    2016 Excel
    Posts
    16

    Re: Add ActiveX controls to toolbox

    Rorya,

    Thanks for your input. Yes, it links an Excel cell to the ComboBox. And the cell can be updated from the ComboBox, but only after _Exit event as far as I can tell and not on _Change. The ActiveX ComboBox can change the value in the linked cell as each character is entered (_Change event). I haven't (at least as of now) been able to achieve this through using the ControlSource property of the UserForm ComboBox. Your input did clue me in as to how to place a default value in the ComboBox, and I thank you for that.

+ 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. Form Controls and ActiveX Controls - Option Button
    By mmchaley in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2021, 05:10 PM
  2. [SOLVED] toolbox activeX
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-22-2017, 05:42 PM
  3. Only have a few controls in toolbox
    By Halt! I am Reptar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-10-2012, 02:23 AM
  4. Two Toolbox Controls Questions
    By jmf in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-21-2006, 04:56 PM
  5. Controls Toolbox
    By bob-eastman@symaptico.ca in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-09-2006, 08:40 AM
  6. [SOLVED] Control Toolbox Controls
    By spIky haIred in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-24-2005, 04:05 AM
  7. [SOLVED] Controls Toolbox control vs Form Toolbox control
    By Tony_VBACoder in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-28-2005, 05:06 AM

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