menu

Hi All, The below code creates a PDF from a named range in cell A55 on the "Menu" sheet and saves this to a folder based in a value in cell A52 on the "Menu" sheet. What I'd like to achieve, is that if the value of cell A115 on the "Menu" sheet is "Zone" then output the PDF file to a path in...

Hi I want to create a form which has 2 text boxes for First Name and Last name and one drop down menu which has Year of Birth, so user would enter First, Last and Year of birth and then excel copy that to excel. I know how to do the Text boxes, but not sure if I can do the Drop down menu. Is it...

I have an AxtiveX ComboBox that uses a list with a defined name of "Company" to fill the drop down menu. I also have used some fancy programming described in the link below to create a searchable list like when typing in a Google search window...

I am experiencing issues in regards to the coding required to do the following: I need to generate an email to a specific email address when an individual selects (from a drop don menu) the option "yes or "oui" in cell F10. Also I require the same process to take place in various other cells in...

I have created a menu for my Excel macro workbook, but there is an instance where I would want most of the items listed in the menu to be either disabled/greyed out/invisible. I have been trying to write the code to do this, but can't quite figure out the syntax. I've searched around online...

Hello, Is it possible to capture a context(right click) menu event? Like to show a msgbox when you click delete on the cell context menu. I've searched everywhere online, but I can't seem to find anything. I know that I can make a custom context menu, however that is not what I want. I...

So I just started playing with the CustomUI Ribbon Excel tool this morning. My intent was to 1.) remove all menus from my VBA Project Workbook 2.) create a custom Drop Down Menu (Menu Items Stacked on top of each other and not individual buttons) with Menu Selections calling sub in Project...

I have a custom right click menu where I load up a Userform. When I close the Userform (either terminate it or unloadit), the right click menu still appears. I have tried to select/activate another cell when closingbut Rightclick option still remains. It’s really buggin for the end user to see...

Got this intranet website only accessible at work( so unable to provide link) but I've included the html code relevant to a drop down menu. I'm unable to get a handle on it , have tried by class, name tag, and id using.getelement/s method. There are two such drop down boxes and strangely enough...

Hy guys I search the net, the forum here and every where, and i still have no clue how to do it. Maybe one genius MrExcel will help me. Here's the problem, i got a invoice, on my invoice i create dropdown menu link with a macro. when i choose sellers or compagny in those drop down(yeah i got...

I have an Add-ins Menu Bar (which works fine) defined and processed in "ThisWorkbook" using the code below: The issue is that I need to have multiple copies of this workbook open at the same time. To get multiple copies of the workbook I copy the original existing workbook save it as a...

Below is the code I currently have. I don't get any errors but nothing happens (that I can see anyway) Pretty sure the code is running because I was getting an error in beforeclose until I add the On Error Resume Next Running Excel 2016 Thanks in advance Private Sub Workbook_Open() Dim...

I'm trying to create a reforecast model that will automatically update values based on the month that appears in a drop-down menu. I have the drop down menu created -- it's just a matter of getting the formula to pull the correct value. SHEET 1 has the months in column C through N (row 3)...

IN cell G1 i have a number that changes every two weeks currently that number is eleven. In A19 i have a drop down menu starting at one and going to twenty six. Is there a way i can set the drop down menu to start at the current number based off the number in G1? Example of the data in G1 is...

The Excel Menu Top Left contains option for Move, Size, Minimize, Close Is it possible to add/remove options to that Menu - Such as Remove Minimize - Add Print, Save, Etc? Is it possible to change Color of Title Bar? Thanks

I'm a newbie using VBA. I have a spread sheet to create a cultist for parts. Within this spreadsheet I have several macros to copy and paste information to the cultist page. I would like to create a macro that will run the appropriate macro by selecting the proper macro name from a drop down...

Hi, I've created a simple userform to update data held in a table. I'm trying to execute the code from a command button on a 'menu' worksheet. My hope was that the form would pop up on the menu worksheet and I could update the table from there. However when I run the macro it moves to the...

Hi, I created the following xml in my .xlam add-in file to load a new tab and menu which works but when I click the Icon, I get the mentioned error . I do not have a separate file open with a same named module which I read can cause this problem. The generate call back and validate identify...

Guys, For the old version of MS Access, I remember someone develope some OCX or something related that was possible incorporate a side Menu. Is there a way we implement the same thing on Access 2010 version onwards?

It appears that MS Excel opens macro-enabled workbooks in one of three ways: (1) A pop-up bar that includes an "Enable macros" button; (2) A pop-up dialog box that includes an "Enable macros" button; or (3) No pop-up at all with a hidden "Enable Content" button maddeningly hidden within the...