menu

Morning, I have a cell which is formatted so when it goes into - (minus) figures it turns the cell red, i also have a drop down menu which if "X" is selected from the drop down menu it makes the cell display an "E" with a Green fill, my problem is that when the number is showing minus and i...

I have a combo box that has a ListFilledRange property value of a particular column in my spread sheet. My code is fairly simple after this... Private Sub ComboBox1_Change() Me.ComboBox1.DropDown End Sub Can anyone tell me why when I click on a combo box selection from the scroll down...

i would like users to enter data into sheet named Menu in a column B2 to B12 in B13 i have a drop down menu of sheets i would like the data to be copied to the sheet in the drop down menu in rows

We received this code from another Mr.Excel user a while back and have been using. But now we would like to customize our tab names but when I changed the tab name beyond the standard Sheet1, Sheet2,...... I get an error. Is there a way to modify the code below so that I can customize the tab...

I am working with Form buttons and assigning macros to the buttons. When I first create a button, I can easily assign a macro by selecting Assign Macro from the shortcut menu. If I want to change the macro assigned to a button, or assign it after I have renamed the button, I cannot for the life...

I'm looking for a way to setup a drop down menu that will give a sub menu depending on the primary menu selection and i need the sub menu item to be removed after it has been chosen. But, if I check a box that turns a cell to a TRUE value it will allow the sub item be used again (add it back to...

Ok. This is a bit complicated , but I will do my best to describe the problem. All of these elements are located in multiple Sheet pages (Tabs) within one singular Google Sheet (Workbook). Sheet 1: The MENU Sheet (Tab Name: Menu) allows users to enter a numerical value in the yellow...

I have removed most of them, I just want to keep "Copy" and then add my own macros to the right click menu. However I have not been able to remove Paste options or Link Any ideas what the correct name for these components is? Or maybe a neater way to "removed all" <> Copy Private Sub...

Hi All, I made a searchable ActiveX combo box which works as intended. I also added a button next to it called "Add" which searches a table for whatever value is in the combo box. Once I click the search button, the combo box automatically pulls down the dropdown menu and the only way to...

Hello, I create a custom menu called Marks and I want to access it through a shortcut (for example CTRL+M). Can anoyne help me with the vba code to display it. I want the same effect as ALT+SPACE BAR for displaying Control Menu Thanks in advance.

Hi all, I've created an add-in that is deployed on a network (I keep a local copy for making amendments before uploading to the network). The add-in works fine for most users but for some it disappears (remains in the add-in menu but is unticked and the custom menu disappears) once Excel is...

I am looking to create a drop down navigation menu in Excel, and found this Youtube video that is very close to doing what I want it to do. The only thing that I want to change from the solution in this video is that it doesn't require a Go button. I want the user to simply be able to choose...

Hi, I've some active X controls which have taken on odd behaviour. They are label and combo box controls. As I mouse over them the cursor becomes a 4 pointed thing whether I go to design mode, or not. There's no dropdown action. A right click shows a different menu to the expected one starting...

Hi all, Currently I am am using below codes to create excel menu in Excel 2013. 1. It is creating Add-ins Menu and under Add-ins menu it is creating sub menu called MyMenu with 4 command buttons However I want this menu in different way. 2. I want to create this menu in line with other menu...

My first post here. I know this is an old program--but it does everything I need a spreadsheet to do :) Somehow my Menu bar is all screwed up. With my W7 Pro config, there is a Deep Blue bar at the very top, the menu bar is about 1/3 the width of the screen and is less height than the Formatting...

Is there a way of adding a new menu entry to a shape right click commandbar ? Regards.

Hi there, Hoping someone can help, wondering if this is possible without the use if VBA/macros.... To set the scene I am looking at a tennis match, and counting where a player hits a return dependent on where the serve lands. I have a drop down menu already that allows the user to select the...

Hi...I have several excel applications and I'd like to create a new one just for like a main menu. I can open the target workbook without issue...I have a button in the target the save and close, after closing the target application it then asks to save the main menu application, if you click...

Hello All, I have been searching for the last hour and I cannot find anything on how to add a slicer to a Ribbon Menu. Is it possible? Kurt

Hi folks, hope you can help me. I am using Microsof Excel for Office 365 MSO (16.0.11029.20104) 64-bit. I am trying to create a shared expenses spreadsheet, using the template from this tutorial www.exceltactics.com/how-to-split-bills-and-share-expenses-using-a-free-excel-spreadsheet/ - I...