activex control

  1. R

    Form Control Checkboxes (Not ActiveX Controls )

    Hi Everyone, I'm still new to coding and looking to learn more. One thing I can't figure out and I'm 100% sure its so easy. I am doing this through a Form Control because I know that ActiveX controls on an excel sheet causes resizing when the screen resolution changes. So I have a Checkbox...
  2. D

    Active X buttons become disabled in new window

    Hi, I have a couple of Active X buttons which do not work when clicked, if I use the New Window function (I have a split screen of the same workbook but with different sheets). These same buttons still work fine in the original window. Is there anything I can do to fix this?
  3. Foo_Man_Chu

    Need to know how to size an ActiveX button to be the same size as the cell underneath it

    Hi all, It's been a long time since I've been in here, I'm hoping everyone will be patient with me. I'm using Excel 2013. I have an ActiveX Button control in my spreadsheet. For the life of me I can't figure out how to make the button the same size as the cell it is on top of, meaning the cell...
  4. S

    Set ActiveX List Box Height

    I believe this has a simple answer but I'm having trouble setting the height of an ActiveX Control List Box. The list box is on an Excel 2013 spreadsheet and I would like to have the list box height be either 0 or 88. This is my code (the list box name is ACEI): With...
  5. D

    Inserting ActiveX object

    I am running Excel 2007 and trying to insert an object (combobox, textbox, commandButton, etc) on a worksheet. When I click on the component I want inserted onto the worksheet, I get an error, "Cannot insert object". I use to be able to do this and I don't know what happened. I can insert an...
  6. G

    Using activeX control scroll bar to move line on spreadsheet

    I am trying to use an activeX scroll bar to move a vertical line across a set of graphs in a worksheet. I have a code that will move the line forward with each click of the scroll bar, but can't get it to move backwards when the scroll bar value decreases. Private Sub ScrollBar1_Change() Dim...
  7. B

    ActiveX Control Checkbox Uncheck if

    Hello is any way to uncheck the ActiveX Control checkbox if another check box is checked ? Like if "malе" checked uncheck the "Female" check box ?
  8. G

    Excel 2007: List Box (ActiveX Control) with multiple columns?

    I am working on an electronic version of an existing paper form. The user must be able to make multiple selections from 18 choices. Each choice has a corresponding check box. I have a List Box (ActiveX Control) with the following properties set: ListStyle: 1 - fmListStyleOption MultiSelect: 1...
  9. Z

    Form/ActiveX control to cycle through 6 different statuses

    I'm playing a volleyball tournament recently and was thinking of setting up the lineup for our starters. Since there are rotations in volleyball games, I was wondering if there's an easier way to press a "toggle button" (except I have 6 different statuses instead of 2) and a clock-wise rotation...
  10. D

    Toggle large group of ActiveX OptionButtons at once

    I created a form in Word 2010 using many ActiveX OptionButton controls across numerous GroupNames. After configuring all of the buttons I went through and tested them to make they were all grouped properly; now a third are set to "true", but I want them to all be set to "false" before I...
  11. S

    Reference Grouped ActiveX Controls Using a Variable

    I have 32 checkboxes in a few different groups, each box is named EasyReviewXXXXXCheckbox where the Xs is a different 5 letter code for each box. I'm trying to find a way to reference them using a variable without ungrouping them. The code below seems to skip over any objects that are grouped, I...
  12. T

    Compile Error on checkbox in command button

    Hi all- I need some help on a (hopefully) simple problem. I have a sheet that contains an activex command button and several checkboxes. when I click the command button I get a "Compile error: Method or data member not found" at this point: HedgeSheet.CheckBox3.Visible = True and...
  13. G

    Form Button Increases in Size while Projecting

    I have a command button on an excel tab with a macro embedded in it. It works fine but for training I need to project it on a screen and once I do that the size of my button increases every-time I push it. Is there a way to lock the original size in? It become huge where I cant see other things...
  14. J

    VBA Copy Range with Variables...

    Hey all, Been pounding my head over this one (Win7/MSO2010). Basically, I'm trying to select a range of cells from one sheet and copy to another sheet using VBA. The sticky part is that I'm copying a range of cells using a For/Next loop and identifying the cells on the destination sheet using...
  15. H

    OLEObject Listbox Problem

    I am having trouble adding values to the ActiveX listbox added to the sheet with the following code. I also don't know how to change the number of columns and the font characteristics of each column dynamically. Thanks for any help. Sub loadBasisV() Dim i As Integer Dim j As Integer Dim...
  16. B

    Enable ActiveX control in protected worksheet

    I am stuck! I have a worksheet that is protected. However, I have an ActiveX control button that I want users to be able to use. I have tried building in the unprotect functionality into the ActiveX control as follows: Sub PrefSelection() ' ' PrefSelection Macro ' ' Sheet13.Unprotect...
  17. G

    Excel 2007 ActiveX CommandButton changes size and font

    I have several workbooks with ActiveX command buttons which call userforms. Recently the command buttons have started shrinking or growing with every activation. As well, the font is smashed into a small point in the middle of the button. I have changed properties, text size, font, deleted...
  18. H

    Difference between Forms_Button & ControlToolbox_Button

    Hi, What would be the procedure to change the caption of the command button created through Forms and Control Toolbox? Example: I created a Command Button on Sheet named data through the Forms Toolbar. I can use the following code to change the caption of the command button...
  19. N

    How to unhide a row containing Activex controls in Excel 2010

    I have some Activex controls on rows. The controls are formatted to "Move and resize with the cells" so that when the rows are hidden the controls hide too. This is for an interactive form where only relevant sections are visible. All works OK in 2003 but not in 2010. When the workbook is...
  20. J

    VBA Checkbox Question

    Morning all, I've been looking around to a solution to this for a while, and have not gotten past a particular point - looking for some expert advice. I have a spreadsheet with active data in rows 12 to past 600+, which tracks a particular process. The end result of the process is essentially...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top