editor

  1. A

    Filter dataset with multiple parameters

    Hello there, this request is far beyond my capabilities of excel and I'm hoping that it can be done. I have a dataset as an example below: <tbody> A B C D E 1 <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>Email address <style...
  2. L

    VBA code already there in brand new file

    Hi I closed all excel files. I opened a new one by clicking on excel icon. I go to VBA editor and I see some codes there? Why and from where they came? Thank you very much.
  3. C

    Power Query - editing tables

    I used Power Query to import file from folder. I then “close and load data” and a table appears. My question is this... Can I make changes to this table (deleting rows, etc) without having to go through Power Query editor? So far, whenever I alter the table in anyway, it will revert back to...
  4. G

    Checked out Excel-file doesn't show in VBA Editor

    Hi all, I have have a code that will copy information from one workbook to the other. I have the Source workbook open, and it will show in VBA editor. When I check out a file (from a program at work) it will be saved in a local checkout folder on my computer and the file opens in Excel...
  5. G

    Assign Procedure/s to VB editor toolbar commands

    Hello, Is that possible to assign macro procedure to a toolbar control (within the VB editor not on Worksheet)? https://i.imgur.com/pjbyXJe.jpg Thanks, Giorgi
  6. M

    Customised Ribbon using Custom UI editor for Microsoft Office

    Hi. I have created a new ribbon using the editor and have created about 60 new tabs. Well as you imagine having all these tabs are a bit of nightmare scrolling along to find the tab i want. Does anyone know if there is a way of using a macro to search for a particular tab, maybe a combobox...
  7. I

    DIY VBA Excel Ribbon Editor

    Hello! In short: I would like to create Excel Ribbon Editor for Windows using VBA. Doeas it make sense? :) I found two types of excel ribbon editors: Editors such as Office RibbonX Editor (famous Ron de Bruin site). This editor just help user to change add own xml ribbon file to excel file...
  8. D

    Closed Files Remaining in VBA Editor

    I have Office 365 on Windows 8.1. There are no Add-Ins. When I close a certain workbook it still appears in the VBA Editor. Reopening the workbook sometimes produces another instance of the workbook in the VBA editor which also continues to appear in the VBA Editor after closing the workbook...
  9. V

    Power Query editor refresh running slowly, Microsoft Mashup Container running even when idle

    All, I have cleaned up a group queries that transform some data for monthly FP&A analysis we do. Without tedious detail we essentially take two exports and combine them into one, and then pull from each previous query (M-Code starts with a source like #"Join Pricing Data") to pull from that...
  10. M

    Using '&' symbol in RibbonX

    I'm creating a custom tab in my Excel workbook, using the Office RibbonX Editor. For the buttons that will be on my tab, I am using supertip to show a description of what the button does, if the user hovers over the button. In the text I want to appear, a character that I want in the string is...
  11. S

    Clipboard History issue in VB Editor

    If I use Clipboard History in the VB Editor, the text content of the clipboard is hidden unless the Copy was done in Notepad or equivalent. Copies done in VBE paste OK, but you're pasting blind, which is useless My problem is that I work in VBE most of the time, and I've never been able to...
  12. E

    VBA Editor not autocompleting

    Why is my VBA Excel editor not autocompleting while I type the code? For example: if I type "Selection". I'll usually expect to see the list of things I can do with it. Maybe I disabled any setting? Thanks
  13. L

    Excel power query

    HI all, I've generated a query from a folder containing dozens of workbooks. I'm using table 1 from each workbook, in the query editor I have all my data including the source workbook, but I want to add the filepath to each row. How to I add an extra column with the filepath inside the...
  14. mikecox39

    Alt-F11 does nothing, security set to allow all.

    Alt-F11 toggles the text in the green title bar gray and a tiny shadow appears around the window. Alt-F8. Displays my macros but Edit option only closes the window and the text in the green title bar blinks gray. In the Trust Center/Macro settings I have Enable all.... set. I also have the...
  15. B

    Can i use a ribbon editor within excel with out having to get other users to download the editor program

    I am recently self taught on using a ribbon editor to set up some ribbon on my excel program that other people use on different computers (not linked in any way) and all is working well, however i was wondering if it is possible to have the codes in my ribbon editor somehow included in my excel...
  16. L

    Use Query To Get Specific Rows

    I need to extract specific rows from all the spreadsheets in a directory. I can use the Query editor to load all of the workbooks but the there isn't a quick choice to select certain rows. For example, I would like to keep rows 4, 53, 57, 71 and 57 from all of the loaded workbooks. I suspect I...
  17. RJSIGKITS

    VBA MsgBox if cell contains specific text

    Guys. What am I doing wrong, please? I need a VBA message box to pop up if and when a specific cell has specific text in it as follows: Private Sub Worksheet_Calculate()If Worksheets("Home Quote").Range("D33").Value = "Selection Error" Then MsgBox "Please make another selection" End If End...
  18. JenniferMurphy

    Can I always have the Advanced Editor on?

    Is there a way that I can have the Advanced Editor active when I reply to a thread? When I start a thread, like now, I have the Advanced Editor. But when I reply, I get some other editor and I have to click on the Go Advanced button to get it. In my Settings under Miscellaneous Options, I have...
  19. JenniferMurphy

    VBA Editor doesn't warn about unsaved changes on exit

    I thought I had made some changes to a UDF, but when I opened up the VBA editor today, the changes were gone. So I ran a little test. I made a simple change to some code, then closed the editor and then Excel. I did not get any warn about unsaved changes or any offer to save them. When I...
  20. D

    Windows Opening in Visual Basic Editor

    I have installed several Excel add-ins that I created on my computer. And whenever I open Excel Visual Basic Editor many of the Code Windows that I have closed before exiting the VBA Editor keep popping up each time I open the VBA Editor. It also happens with some of the forms from those...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top