editor

Hello all, As the title suggests, I am having a problem with Excel's Workbook_BeforeClose event handler. I know I am using the correct method signature (shown below) because it has worked in the past, and I have correctly placed the event handler in the "ThisWorkbook" module of the VBA editor...

I am trying to Create the Open Workbook Event in anohter Workbook. Everything works fine while the VB Editor is open. If I exit out of the File and open it (with VBEditor closed) it returns error 57017. It is very confusing that VBA functions exist which seem to require the VBEditor to be open...

Hi I tried to open editor VBA using ALT+F11 or Menu, but no Open , I see in configuration and I believe is all right See images But Not show editor

Whenever I open the VB Editor all the code windows for (almost) all my add-ins and personal WB always open and totally clutter-up my current project. Is there a way to automatically close them ALL (I'd individually re-open the current project ones I need to work with) at once when the VBE opens...

Does anyone know a good resource for learning the language used in Visual Basic on Excel? I know it's a loaded question since it's a variation of computer programming language - but I am looking for a solid introduction so I can know what I am doing with commands in VBA rather than just...

Hi I have created an editor i.e, a cell or a text box, in which text can be entered manually or from dropdown lists present in the same sheet. If a keyword is inputted manually, it is validated that it must belong to the values in dropdown lists. What i need is There should be a separate...

Hello, I've been looking through a colleague's spreadsheet but have a problem. When I load his spreadsheet into my computer it throws up an error which seems to be related to declaring variables. But, because the error (if it is an error) is in a function that is called in the main spreadsheet...

Is there a way to see the SQL query that someone built in the query editor without actually having the ODBC connection installed on your machine? I assume the query syntax resides in the spreadsheet somewhere, not on the database it is querying. I keep getting the error "[Microsoft][ODBC...