activex

I'm looking for a way to use checkboxes to hide/unhide sheets. I've found code for PCs, but they all use ActiveX. I'm on a Mac and don't have access to ActiveX. Is there a way to accomplish this on a Mac? TIA

Good Morning, I'm sorry if similar question had been asked for several times before, I would like to make dropdown list to navigate between hidden sheet using combo box ActiveX. The script for dropdown sheet list it self I already have it from here like this: Private Sub ComboBox1_Change()...

I'm trying to filter a pivot table when the user selects an item from an ActiveX combo box. (I need to use the ActiveX combo box because after the user selects an item I want a combo box in another worksheet to populate based on the user's selection. I haven't found a way to do that using...

I already attempted making one using activeX and had a glitch (issue is in another forum thread), im just wondering if there is another way to go about it.

I'm trying to set up some basic ActiveX Option buttons ("radio buttons"). I gave them the same group name and linked them to the same cell. However, clicking any of them just makes the first one toggle between clicked and not clicked, and the linked cell just toggles back and forth between true...

Hi, I have a spreadsheet containing 12 ActiveX drop-down lists and 3 check-boxes. I want to create a macro that selects a certain combination of rows and checks/unchecks. I've tried recording a macro, but it won't register any of my selections in the ActiveX controls. Do you have any suggestions?

Hi all, Recent Office security updates has broken ActiveX controls on worksheets .. The usual and rather long-winded fix (Which may not always work) is to locate all exd files and delete them or install the following updates. Here, I took a different approach. I added the ActiveX controls (In...

Hi there, I have an ActiveX control in a worksheet that acts as a scroll bar which enables users to click through different month's worth of data in a dashboard. I just wanted to know if it is possible to have more than one cell in the 'Cell link' field, ideally a cell in a different tab. I've...

Hi, Good day all, I am preparing a forecast for next 10 years for my company. So I used activex scroll bars to control number of units expected to be sold. For example no of units sold in 1st year were controlled by an ActiveX bar and then the annual increase (by a %age) in no. of units was...

Hi, I am working in Excel Pro Plus 2016 and have the issue, when some users open my file, that the scrollbar in the ListBox (ActiveX) shows odd and twice. This is not an issue on my own laptop nor a few other user's, and I cant figure out why this issue occur for some. Users with issue look...

Hello everyone, I've been using Excel/VBA for years now, but I've only just now starting to use an ActiveX control. Here's what I'm trying to do... 1) Create an ActiveX command button (on a sheet) via VBA, 2) Set the button's name, 3) Set the button's caption, 4) Set the...

I have been trying to find a method using VBA that would allow me to have a generic code to use. I have about 20 sheets and each sheet has from 2 to 20 checkboxes (form not activex). How can I make the code without having to do each and everyone individually?

Hi I have an Excel workbook with around 150 ActiveX checkboxes. All these Active X controls leads to long load time when opening the workbook (about 20 sec on my computer). Is there any way to speed up the load time of the workbook (without changing to form controls)?

Hello, I have a couple of ActiveX buttons and if I repeatedly click any of the buttons, I have to click twice in order for it to execute. I can click, go fill out a cell somewhere and come back and I can click once. but If I just try to execute a macro several times I have to click twice. Is...

Oftentimes, I confused myself with OLEFormat and ControlFormat. To clarify my understanding, is that OLEFormat must refer to ActiveX Controls while ControlFormat must refer to Form Controls? Sometimes I notice cross-application of them among ActiveX controls and Form Controls. What is the...

I have the following code to loop through a series of activex checkboxes in a frame. I then want to pass the strReportName variable into other subs and functions. When I hover over strReportName in the code, it is listing the correct string, but when I set a watch for this variable, the value is...

Hi, I have an ActiveX text box in my Excel document. I'm trying to restrict the data type to numbers, so I added code. Even after making sure that the required References were added (Microsoft ActiveX Data Objects 6.1 Library), I'm still receiving the following error message: "Compile error...

Hi All, I am new to the site, and I have come unstuck on something that should be simple. I am trying to create a excel front page that shows a figure in an Activex text box that is changed in colour from Red to Green depending on the value between two cells. I have got the code to work fine...

Hi I was wondering if someone could help? I have 2 checkboxes which cannot be selected at the same time. When one checkbox is selected, an entire row is hidden if the cell in column A ="X". Now I also need to change the value in column F to "N/A" in the row that is being hidden. What would...

I have a beautiful looking layout that is user friendly. I have a "Heading" row that denotes a "Category" below it. I have several Categories. In each Category is a series of cells that are fill-able as an "Entry." Each Entry has it's own functions and so on. Each Entry uses the same "Template"...