1. O

    There are no macro's under the Macro name dropdown (while there are in VBA Editor)

    Why do I not see ANY macro's in the left image while I do see macro's in Alt+F11???? This goes for all my workbooks. I have restarted, repaired Office; checked all Trust settings... no clue.
  2. A

    Editing Auto-populated Text

    Hi! I've just been Googling excel forums trying to find a way to do this. I just want to make a cell auto-populate a body of text based on a dropdown menu selection. I know how to do that, though... However, I want to be able to EDIT the text that populates...and I DON'T know how to do that...
  3. N

    VBA - Userform & Image size issue

    Hello everybody, I have a userform, for which I have specified the (Height = 720) & (Width = 1280) properties from the Properties panel. And I have made a Jpeg in Photoshop which is intended as a sidebar menu background in my userform and it's (Height = 720) and (Width = 190) Now, one would...
  4. G

    How to get handle of menu in external application, and find button where no text is part of class.

    @Jaafar Tribak - I have seen that you have extensive experience in this topic so I am hoping that you can help me please. I have an external application that I can launch and control from Excel, but only up to a point. As soon as I click on the SEND TO button and the menu pops up I can't go...
  5. E

    Using SUMPRODUCT with multiple dropdown menus

    Hi, all! I've got a calendar-style sheet (sheet 3) that I'm pulling data from, and I've got the categories in 2 different dropdown menus on a second sheet (sheet 4). I'm trying to get a cell to add up all of the occurrences of certain text within the calendar. I've figured out how to...
  6. T

    Create popup menu to unhide worksheet

    Hi! I am looking for a code that will create a popup menu that appears when a user opens the workbook. The menu would have 4 choices and each choice would unhide a different set of tabs. Below are the menu names and tab combinations. I'm not even sure where to start. TIA!!! Menu Option...
  7. L

    window menu in old excel version

    Hi I am watching the video below and in minute 2:00 he went to Window tab in the menu to find out which excel files are opened. I am using office 365, where I can find that option? Thank you very much.
  8. M

    Chart Formatting Shortcuts in Excel 2016

    In previous versions of Excel I was able to tab into the chart formatting menu that popped up and use the alt keys to jump to the functions with underlined letters. Now when the menu pops up along the side of excel I haven't figured out how to tab into it or use those same shortcuts. Is there...
  9. B

    Relace and Delete Question!

    If I wanted to replace all the 456 items in the column below, then the delete blank rows where the 456 items were, what menu do I use? <tbody> 142 996 456 123 456 226 456 225 456 </tbody>
  10. D

    Right Click a Cell

    Hi, When I right click on a cell I get a drop down menu and a box containing tools above or blow it, I would like to customize this box of tools and the drop down menu also, is this possible. Thanking you in advance. Regards, Duncan.
  11. N

    Name Manager and Spaces

    Is it possible to have the name in the list show up on the sheet without the underscore? I have a dropdown menu in a cell which dictates what shows up in a drop down menu of another cell. I don't like how it looks with the underscores... is there a fix, or do I need to get over the cosmetics...
  12. C

    Fill Handle Menu Replaced by Quick Analysis Menu

    Hello all, I have searched and searched but I have not found a thread covering this particular problem. Historically, when I have double-clicked the lower right corner of a cell, it will automatically autofill the cells below and offer a fill handle option menu (Copy Cells, Fill Series, Fill...
  13. S

    Running Macro to fill in new cells without affecting cells already filled

    I have a macro that will be run several times throughout a worksheet. First time I run macro it will fill column AF down to a certain # of rows based information in column A. Lets say in this case row 20. Then if we need to add more rows below this, I want to re-run the macro so it will...
  14. G

    VBA change sheet on data validation selection

    Hi, I have not used VBA in months and my first task back is trying to create a menu page which will have a data validation drop down with multiple selections on there which I want to link too certain sheets. So when selecting "test" from the drop down list then it will take me to the "test"...
  15. S

    Copying data between worksheets dependent on drop menu selection

    Hi All, I am attempting to create a spreadsheet and would like to know if it is possible if somebody selects "yes" from a drop menu options of "yes/no" that the row is automatically copied from one worksheet to another that is password protected? I want the first sheet to accumulate the workflow...
  16. F

    Right click context menu

    If I use Shift+F10 for any selected FormControl/ActiveXControl/Shape, the correct context menu appears. But if I right click the object, I get a menu that reads : Move Here Copy Here Cancel Anyone know how to fix this?
  17. A

    (3) Dropdown list to equal $

    Greetings, is it possible to have (3) dropdown lists equal a dollar amount? Task at Hand: I will try to simplify to help make sense. Let's use a restaurant menu as an example. Depending on your order and the options chosen, the total will be different. Dropdown list 1: Types of meat-Chicken or...
  18. J

    use excel to input data into a program

    We have a program we use for some work, its a exe file that runs in a dos window. It starts with a menu of 5 choices, and I would like to use excel to populate the menu choices, and also other operations. Is this something excel can do, or is there a better way? It would involve opening files...
  19. M

    Cancel=True Not Working As Expected

    I do a lot of coding for the event right-click. I end my additional steps with Cancel=True which used to always avoid popping up the incell menu. Now, for the past many months, the cancel=true seems to no longer work and I get an annoying right-click menu that pops up after my code executed...
  20. P

    Where is the "start import at row" option in Excel 2019?

    I'm trying to import some text from a CSV file, but I don't want to include the headers, which the CSV file contains. I've been told on a previous thread I posted that there's a "start import at row" option where you can select the topmost row to import. That thread seems to have died a few days...

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
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 "".
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