code window

  1. D

    Can't open module windows in excel vba

    I have 4 macros in my ribbon, all located in my personal macro workbook. They are no longer running when I click the buttons. I get the error Macro may not be available or all macros may be disabled" I do have my macros enabled. When I open up the IDE I can see my modules under my personal...
  2. T

    HELP! Cannot right click in code window/IDE

    Hi All Flummoxed, I am! I can not right click all lines of my code in the code window. For example in the below partial extract (with no code running) I CAN right click the line UsrName = Environ("UserName") and get all the usual options. But if I right click Call...
  3. P

    Limited Code shown in developer window

    I have just joined this forum because I was having trouble with the formats for displaying my code in VBA My first problem was not being able to 'dock' windows - shown on this post and solution suggested by Marcelo Branco (thank you) http://www.mrexcel.com/forum/showthread.php?t=607518 Having...
  4. L

    Countif/sumproduct formula

    Hello, Yesterday I got some great help with a problem (see http://www.mrexcel.com/forum/showthread.php?t=348357&goto=newpost) and I need some more today, please. I have a sheet with repeated dates for several months and I need to break out data by week and then by certain criteria. I can do 1...
  5. C

    Listbox Scroll

    I have a userform with a multiselect listbox the user seraches using a textbox. I am using the following code to do the search. the only problem is that the results appears at the bottom of the list and I want it to appear at the top. Private Sub TextBox1_Change() 'the change event runs...
  6. B

    Close All Open Code Windows

    Is there a way to close all open code windows without closing VBA? Is there a shortcut or a macro to accomplish this goal?

Watch MrExcel Video

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