activex

This is my first attempt at using vba or activex controls so please bear with me. I created a command button in my document to use a macro (that I recorded) to copy these 2 boxes (merged) and duplicate them. It works well, but the new boxes appear above the old ones (where I drew the red line...

Hello guys, first time posting here (an first time posting in a forum ever). I'm desperate. I am programming an Excel File to act as a game interface (a very simple one, for a gamification project in my company). The thing is that I want to create an ActiveX button (why an ActiveX and not a...

I am using MS Excel 2013 in a new PC. In my original PC, with MS ExceI 2013, I can hover my mouse cursor on an activeX object and then click on it to run VBA code successfully . However, in this new PC, also with the same version as MS Excel 2013, whenever I hover my mouse pointer on any...

Hi - I’ve got a worksheet with multiple ListBox form controls (not ActiveX) that I need to extract the selections/inputs from. There are 6 different listboxes all with multiple selection and about 40x of each. They are aligned by row, e.g customer 1 in in row 1 has listbox 1 in column A...

Hi, I have a recorded macro that copies existing worksheet and pastes it to the right. The existing sheet has 4 ActiveX buttons (Each have their own related macro in the background). The code is; Sheets("Sheet1").Select ActiveSheet.Buttons.Add(2118, 114.75, 131.25, 22.5).Select...

Hi I can insert a Form Control and then assign Macro to it (right click, assign macro). But that is not the case with ActiveX Control. There is no "assign macro" option when you click on ActiveX Control. What is the reason behind that? Thank you.

Hi What is the difference between Form Controls and Activex Control? Why we have both? Thank you very much.

I have an activeX combo box on sheet 1 of my workbook and a list of names that this refers to on sheet 2. When I click on the name shown in the combo box I want it to copy the name in the link cell to the active cell on sheet 1. Can someone please help me to write the code for this to happen...

Situation: I'd like to create a worksheet where it will be used by project managers to request their change of service of their clients. I have an idea of what I want to do. Make column 'A' a static menu and have macro buttons that, when pressed, will unhide columns to the right. Those columns...

I've successfully created an ActiveX Combo Box and used ListFillRange to identify the correct range of text to appear in the drop down. The problem I'm running into is when I exit design mode and try to use the combo box, all the options show up in the drop down but no matter which one I...

Greetings, I have a question for which I cannot find the answer to anywhere. I'm using the Microsoft Date and Time Picker Control in a form at the request of leadership who want to choose the date for the form. The info doesn't go anywhere, it just shows up on print outs. The problem: This...

Hello All, I have successfully created a searchable drop down box using the ActiveX Combo Box tool. Under Properties there is a "linked cell" row. I am not able to identify more than one at a time. Does anybody have a solution for using multiple cells and/or a different approach to creating...

Dear all, I want to have an solution for next thing. I have activeX control drop down box and when I used it and it give results there is no problem. but when a select or edit an other cell and enter then the drop down menu expands??? See below my code, hopefully somebody can help. Private...

I have =CUBEVALUE() functions referencing twenty Lists created with Data Validation (Bolded below). =CUBEVALUE("ThisWorkbookDataModel",$B$2,$B$3,$B$4,$B$5,$B$6,$B$7,$E$2,$E$3,$E$4,$E$5,$H$2,$H$3,$H$4,$K$2,$K$3,$K$4,$K$5,$N$2,$N$3,$H$7,$A$1,$A12,B$11) The limitation is that only one value per...

Hi, I have a workbook that contains of many worksheets, and I have been looking for an VBA code to get all these worksheets in a drop-down menu to make it easier in navigating between these worksheets and in order to save some time when searching for a specific data that is related to a...

Hello I am looking to transfer text from an Activex Textbox in one sheet to another Activex Textbox in another sheet? Can anyone help? Many thanks

Howdy So the project I'm doing has me at a crossroads. The PERFECT candidate for what I'm trying to achieve is a Frame control. It's isolated, scrollable... it's just that in a worksheet they're the devil. Simply trying to add one at runtime throws up odd exceptions and bugs ("Cannot enter...

Hi all, I have a sheet with numerous Activex optionbuttons. I have a reset macro which would put the value of each button to false, this used to work fine but I added a new optionbutton (no big deal I thought) but now the macro runs but doesn't change the value, the code is below and any help...

Hi there, I'm relatively new to VBA, although have been picking it up quickly in the past month or so. I have been working on a spreadsheet that completes several actions dependant on certain cell's values in the spreadsheet. The spreadsheet essentially is used to analyse a time sheet; colour...

Hello, I am trying to create a form in MS Word that a prospective member can fill out and return and the corresponding data fields can then be deposited in an MS Excel sheet. I am using a mix of ActiveX Controls (Text Box and Check Box) as my form fields. I have done some browsing for solutions...