active x

Hello Masters, I hope you can help me with this one. Im updating an old Excel sheet with some macros (.xls) to a newer format (.xlsm). I have very little experience with Visual Basic and Macros. The problem is that i want to create an updated sheet that works both in Mac OS and Windows , but...

Hi Folks, I have an active X listbox that likes to move positions around on my worksheet so I want to place it on a userform instead, but then that takes me out of my depth in knowing how to, 1) Populate the listbox selections with a Named Range 2) Return the number (ie Integer 3 for the 3rd...

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...

Good day all. I have a Active X ListBox that is linked to a cell. The list range is a list of serial numbers that is used to add additional information on the spreadsheet with a vlookup function. The listbox is working almost as expected. The number that I select in the listbox, is transferred...

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)?

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"...

Hi There: I inserted and Active X control (checkbox) and want it hidden if a certain cell (V1) = FALSE. I have the following code I have entered: Private Sub worksheet_calculate() EnterMonthlyBox1.Visible = Not Range("v1").Value End Sub Problem is when I do this the UNDO function is...

I don't know if this is possible, but I bet it is! So basically I just want to embed an Active X button (which I got that far :P), when it's clicked, I want it to read through certain cells and return if any of them are blank. So say the button will be on L2, and I want to be able to click...

Hello, I am trying to use an If /Then Statement in order to change the output of a program I am making. I want to be able to change the value of a cell (through a data validation dropdown), change a certain output and have this happen after a certain Option Button is selected. For Example...

Hi all, I currently have an ActiveX Combo Box set up with a dropdown list of values. I previously had these set up via Data Validation as normal dropdown lists, however, switched to Combo Boxes to allow the predictive text feature to be enabled. Now, I am wondering if it's possible to do...

Hello everyone, While I know how to use option buttons in the Developer tab under Form Controls, I am new to the ones in ActiveX. I believe I need to use the ActiveX ones, based on the following criteria, but correct me if I'm wrong: 1. I have 5 sections on the same "survey" form (one page) that...

Good morning everyone. I'm stuck on using a code to hide rows using an active x checkbox. I'm still trying to understand VBA codes. I would like to show if check box is checked, all rows will be unhide. If it's not checked, it will only show rows that has a value in column B. This I what...

Hi, I’ve recently had some trouble with my active x controls and now every command button or check box I enter starts at 21 instead of 1. This happens in existing and new workbooks (and I’ve already re-installed office) This makes me think that there are some inactive active x controls on...

Hi, I have a file with multiple active x controls to filter and modify a set of data. When I send this file over e-mail, the active x controls don’t work on the recipient’s computer (tested with multiple recipients). On the recipient’s computer, my code is still saved but each active x control...

Help! I've had a Macro made in PowerPoint (I'm aware VBA in PowerPoint is different to Excel but hoping someone speaks the language), sending it to my client and him (and his team) are getting a dialog box come up saying "Compile Error method data not found" when filling in the form. I am not...

Hello, I am attempting to use an ACTIVE X combo box. to deliver the desired function. What i would like to do, is make a selection from the drop down combo box, and depending on what i select, have it populate other fields. PLEASE HELP!!!

Hi All, I having a problem with a run time error code that occurs when I attempt to copy and paste data from one worksheet to another sheet. basically I have 3 sheets 1 sheet (sheet1) is used for data entry, the op enters int various cells and textboxes by pressing a command button which...

Please read and assist if you have a solution...:confused:. I have worksheets that require a check boxes to hide or unhide Charts or additional worksheets - nice feature! After a (un-repetetive) few clicks and or unclicks the check boxes freak out and the text associated with the check box...

I created a user interface in an Excel worksheet. There were a few Active X buttons which loaded data and created reports. It worked fine on my computer. However on someone else's laptop the buttons were larger that they should be. I don't think it was screen resolution as the rest of the sheet...

Hi again. I have a workbook that has a sheet with a lot of columns. I also have a sheet before it which I want to put checkboxes on which will toggle columns on the second sheet hidden/unhidden. I'm using an active X control checkbox form, but I can't figure out how to add multiple...