1. P

    How to define ActiveX TextBox's LinkedCell property with a formula?

    Hello, I'm trying to make a search function, what looks for the entered value in an array, and links a TextBox to the search results neighbour cell. I have the formulas needed to get the row, column or address of the cell that should be linked, but I can't select a linked cell as a...
  2. P

    Using named range as list for an ActiveX combo box.

    My Set Up I use Microsoft Office Standard 2013. I have a Table that self populates and formats itself dependant on value selected using an ActiveX Combo Box. I use a Named Range as the list for that ActiveX ComboBox. My issue - making any change...
  3. M

    Transfer activex textbox value to table on another sheet

    Hi, I have a sheet called "CLP", there are several activex textboxes in this sheet. I want to use VBA to transfer the values of each textbox into a specific named range on a table ("Data") that's on sheet "CLP Client Data" So for example on sheet "CLP" there is a textbox named "TBDate", i want...
  4. M

    Clear all activex objects

    Hi there, I was wanting to clear all of the activex objects on my sheet but am unsure how to do it. I tried the code below but it doesn't work. Currently i am using textboxes and comboboxes but thought it would be good to cover radiobuttons and checkboxes too just in case they're added later...
  5. T

    VBA Insert Row using ActiveX Radio Buttons

    Hello, I'm new to VBA. I'd want to insert a row under in two columns only using "yes"/"no" option buttons (as shown). When "yes" is selected a new row will be created. If "no" is selected then the created row will be deleted. Hoping for something simple enough that can be modified & used...
  6. D

    Changing the toggle button setting during another macro i.e., without physically clicking it

    Hi Folks, I have a Toggle button on one of my sheets called: LocationFormat. It works a treat. My question is: can I add VBA code to another macro in order to turn off or turn on the Toggle button, i.e. so it automatically changes state when I run another macro? Kind regards, Doug.
  7. J

    ActiveX Input Format as currency with 2dp

    Hi All, I have been trawling the web and Mr Excel for an answer, but everything I have tried doesn't work. I am creating a userform that users need to be able to add in monetary values. Below is how I have the textbox set up at the moment, but it's not doing what I want: Private Sub...
  8. C

    ActiveX ComboBox Default Value changeable

    Hi, I've been struggling with this problem for awhile. I've made a form out of ActiveX controls, vba codes etc. I am almost zero knowledge about vba. I've made a combo box, named cmbDate. ListFillRange of the combo box is Q11:Q13, where there are formulas in this cells: Q11...
  9. G

    Code changing color of text stored in ActiveX Text Box

    Hi, I am having an ActiveX Text Box control in my worksheet which is linked to a cell data. I want to change the color of the font of the text box based on certain condition. What is the VBA Code for this task? I am trying with the following but not working...
  10. A

    VBA - ActiveX button

    Hello.. Assuming i got 2 sheets and 2 ActiveX button. Sheet 1 with Button1 and Sheet 2 with Button2. Both button contain the same coding which is for adding row above the button. The question is, how to trigger clicking Button 2 automatically when i click Button 1.
  11. M

    How to suppress compile errors generated from ActiveX code being present on MAC

    I have a workbook with code referencing activex objects that isn't supposed to be ran on if the user is on Mac, however after the user gets out of the initial read only mode upon receiving the document, ActiveX objects are deleted. Trying to run certain macros will then result in compile errors...
  12. C

    How to reference an active ActiveX control?

    Hi everybody, I'm writing an 'on_click' event for one of my ActiveX labels. But how do I reference itself in the code? I need to derive the label's name when I click on it. Is there a way on how to do it? thanks...
  13. S

    [VBA] manually-select ActiveX commandbuttons & change font size

    I need to manually select certain ActiveX commandbuttons on a worksheet, and then change its font size. Below is my attempted code but returns error. Sub Testing() Dim o As Variant For Each o In Selection o.Font.Size = 20 Next End Sub Thanks a lot!
  14. K

    Fire change event for ActiveX combobox

    Hi all, I have an issue with an ActiveX combobox. In my workbook, an activeX combobox is created each time a cell is clicked. I would like to trigger an event so that when the value of the combobox change, it triggers an event that modify the adjacent one. My problem is that, as you know, the...
  15. M

    Possible to check if user is on a MAC using ActiveX or Scripting.Dictionaries ?

    I would like to know if creating these two objects while on a MAC would create an error that can be used to adjust the workbook accordingly. Thank you for your time.
  16. X

    excel add web page(with slicer)

    Hello Friends, I know that i can excel export the web page, But I'm wondering if i can add a slicer (list) and activeX (button) excel export the web page? Work on slicer (list) and activeX (button)? my excel export the web page, But did not work -- slicer (list) and activeX (button) in...
  17. E

    Excel from windows to MacOffice

    Hello guys, I have a few questions about excel on windows and on Mac. I have a file that has buttons in it, on windows they work fine but on MacOffice they wont work. I've read that ActiveX wont work so I have to use the form buttons. My question is. Activex buttons give me more options to...
  18. T

    Excel warnings

    Hopefully a quick question. In my sheet I was playing around with some activex controls for a certain function. When I realised what a headache all the warnings were on startup, especailly as this workbook needs to be distributed I quickly got rid of them all and reverted to standard...
  19. L

    NOOb Question. Excel game not working in 365

    Hello We have a very popular game we play at our workplace called bubble shooter. However after the company has updated to windows 10 and excel 365 the game no longer works. When I run the compatibility checker it says "Uninitiated activex controls can not be transferred to the selected file...
  20. S

    Dynamic Picture Viewer

    Hi, I have a list of image file names (minus the extensions) in column A and an Image ActiveX control embedded on Sheet1. Could you help me with a code that would access and display the images? For instance, when a cell in column A containing "Image1" is selected, Excel should access...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back