1. T

    Conditional Disabling of ActiveX Controls

    First of all many thanks to many of you for providing me with amazing solutions to my large and small Excel problems. So far I never had to post and so I never had an opportunity to thank you before this. What I want to do disable certain ActiveX toggles depending on the value of a specific...
  2. D

    Please explain Control Toolbox

    I notice there are two Control Toolboxes. One for forms and one for ActiveX. For example, what is the difference between the ComboBox tool in the Forms Control and the ComboBox in the ActiveX?
  3. G

    Using "cuadro de controles" in spreadsheets

    Dear Sirs. I saw a very great spreadsheet that came with some "cuadros de control" in it. They were very helpfull for people that have to manage the spreadsheet and choose between options without having to learn how it realy works. These "cuadros de control" work very well because you can only...
  4. B

    VBA code to change PivotTable selections, based on ActiveX CheckBoxes on a worksheet.

    Hi everyone !<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> I really need your help on this one and would really appreciate any suggestions you may have for me !<o:p></o:p> <o:p> </o:p> The thing is that I have an Excel Workbook with Raw...
  5. milesUK

    Me.LinkedCell type reference for 48 Controls!

    I have a single worksheet containing 48(!) spin button controls over cells B2:D17. They are named SpinButton1 through to SpinButton48 across and down this range. Each one has it's LinkedCell property populated with that cell over which it is placed in the sheet. I want a SpinButton//_Change...
  6. M

    Activex Controls Changing in Size

    I am using the command button, option button and checkbox activex controls in a workbook. I have set the font type and size in the properties, set the format control lock aspect ratio on and object positioning to Don't move or size with cells. With this, the activex controls will randomly get...
  7. M

    Setting a Font in ActiveX Declaration

    Does anyone know what the code should look like to set the initial font (font, style, and size) for an activeX controll. I know to set other properties it is as easy as: Selection.Object.MultiLine = True Selection.Object.ScrollBars = 2 The font however seems a bit trixier. Thanks in advance...
  8. M

    Dynamically Linking ActiveX Command Buttons

    I am currently working on a project where I have a collection of textboxes which are storing various entries of text. Next to those textboxes I am trying to add some buttons, that when clicked, call a userform that is used to add a new entry to the respective text box (the boxes being otherwise...
  9. M

    Creating Multiple ActiveX Textboxes

    I am currently working on a project that will allow a user to enter comments in a text box. From there, I would like to allow them to send that comment to a read only, scrollable textbox placed next to its respective label in a spreadsheet. So far, I can get all of this to work with only one...
  10. J

    Illegible caption on command button

    In Excel 2003, under XP, I am placing command buttons from the controls toolbox on spreadsheets. The captions are not shown in the default or selected fonts except when the button is clicked at run-time. Then the font returns to its hard-to-read state. I seem to recall finding a solution to...

Some videos you may like

This Week's Hot Topics