user-defined

  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!

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top