1. R

    UserForm X disabling

    Hi all, I am trying to disable the X on some userforms and have the following code: Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) If CloseMode = 0 Then Cancel = True End Sub But when I run the code, it tells me "user-defined type no defined" Am I placing...
  2. B

    Auto-Populating cells with user-defined data after adding new rows

    Good evening, I have a macro that looks for user-defined criteria, and then inserts a new row every time the criteria is found. What I need to do now is populate the A and B cells in the NEW row with additional user-defined criteria ( cell A? will be a number, and cell B? will be a text name)...
  3. G

    Hidden user defined formulas

    Hello everyone ! I am currently working with an excel file where one of the used formulas is somehow hidden ( I can't view the code to see how the formula works ) . In VBA editor there are 3 references ( XLA ) used where one of them was password protected. I managed to unlock it , with a hex...
  4. E

    Broken Link to User Defined Formula In Add-In

    Hi, I have a problem that I cannot find a way to get around as follows: I am using a link to a user defined formula from a 3rd pary add-in. I am using the file on two computers (home and office), one running on windows 7 and the other is XP. The file uses a full path formula, i.e. C:/Program...
  5. R

    specific compile error

    I get the following error when I run my code: "Compile error: User-defined type not defined" VBA highlights this line of code: Public msg As New TibrvMsg I think maybe I'm missing a reference or something in tools/references. Any recommendations? Thanks!

Some videos you may like

This Week's Hot Topics