1,574 questions with Developer technologies | Visual Basic for Applications tags
How to automate Visio Import to build Org Chart
I am trying to make it easy to refresh a Visio Sup Org when data in the linked Excel is Refreshed. The refresh button updates the data but not the structure and the only way I've noticed that creates a new structure is by using the import button. Is…
Developer technologies | Visual Basic for Applications
How to fix this macro for Word
Hi! I have been using the same macro for 3 years and it suddenly stopped working. My purpose of this macro is to take a mail merge and create PDFs with customized file names. They imported straight to a network folder. I now receive error code 5825 no…
Developer technologies | Visual Basic for Applications
Microsoft Access Duplicate Button stopped working with windows 11
Duplicate Button = Command44 (Used to work with Windows 10, Not working with windows 11) On Click = Event Private Sub Command44_Click() On Error GoTo Err_Command44_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem…
Developer technologies | Visual Basic for Applications
How to reopen a UserForm in File A with the selected row after navigating to File B?
In file A (.xlsm), there are multiple rows. When I select a row and click a button, a popup form (.frm) opens. From this popup, I click another button that opens file B (.xlsm). After clicking a button in B (.xlsm), it should return me to file A (.xlsm)…
Developer technologies | Visual Basic for Applications
fix a macro
I have a worksheet called sit, in column KL from row 2 down to row 300 I have some rows the number 1 and some rows have a * there are no blank rows. when the macro is selected it will only show the rows with the * and the row with the number 1 are…
Developer technologies | Visual Basic for Applications
VBA and good
VBA Cde to add good morning afternoon and evening into word How to set up in full Mod moved from : Windows for home | Windows 11 | Settings
Developer technologies | Visual Basic for Applications
How to fix microsoft visual basic run-time error '1004': Application-defined or Object-defined error?
How to fix microsoft visual basic run-time error '1004': Application-defined or Object-defined error?
Developer technologies | Visual Basic for Applications
Excel 365 VBA Library not found -> Tools-References are greyed out
Excel VBAs do not work in new Office 365 environment. Error mesage is "missing library". The tab tools-> references is greyed out. The VBA7.dll exists in the .../Microsoft Shared./... folder, which is not exactly the same as in my other…
Developer technologies | Visual Basic for Applications
macro to remove profanity and swear words in word files
Hi there, I edit books with on aspect being removing swear words. I have never used a macro but there probably is a way to remove a set of words with **** or simply blanks. How can this be accomplished? Many thank, L. Mod moved from : Microsoft 365…
Developer technologies | Visual Basic for Applications
Text box using vba
Hello from Steve Object is to create an input box using vba When I push the macro button I want to insert the input box With "$" inside the input box please. I will put the cursor as to where In need this input box. I will the type 4.00 which…
Developer technologies | Visual Basic for Applications
VBA class implementing variable missing Interface properties and methods
(Environment: Excel from Microsoft 365 Family, current, just now, with available "Current Channel" updates, on Windows 11 Pro--also more or less current via Windows Update.) I've Googled numerous sources describing how to have an object,…
Developer technologies | Visual Basic for Applications
Need Power BI + Excel sandbox access in Microsoft 365 Developer Program
Note: None of the available sub‑tags match my issue. This is about the Microsoft 365 Developer Program sandbox access for Power BI and Excel. Hi, I joined the Microsoft 365 Developer Program to build a reporting prototype using Power BI and Excel.…
Developer technologies | Visual Basic for Applications
what did i do wrong in the sintaxis of this code while using powerfx?
Set( VarUsuarioPermisos, LookUp('UsuariosControlFacturacion', Correo = User().Email) ); When i use any other function than LookUp i dont have any problem on using the table "UsuariosControlFacturacion", also dont have any problem with…
Developer technologies | Visual Basic for Applications
Sorting with Left to Right Orientation in VBA
I was researching how to do this but I see syntax that varies so I want to be sure I understand and get the easiest way to code the sort command. In the screenshot below, I want to have a sort command that sorts left to right beginning with Column…
Developer technologies | Visual Basic for Applications
32bit userforms cause critical errors with 64Bit excel
32 bit userforms cause critical error wit 64 bit Excel/VBA. The macros and te userform code is not the issue. I have a program with over 80 userforms, some are OK and some are not. So far I have had to rebuild a form in the 64 bit version using all the…
Developer technologies | Visual Basic for Applications
Syntax issue - Cannot figure out
I am getting a "Type Mismatch" for the following code:" yr = Application.VLookup(ListBox1.Value, Worksheets("RideSch").Range("BL4:BM8"), 2) This is what it is referencing. The variable "yr" is DIM as…
Developer technologies | Visual Basic for Applications
what does "Go To 0" do in a macro ?
what does "Go To 0" do in nested in a FOR in a macro? Mod moved from : Microsoft 365 and Office | Excel | For home | Windows
Developer technologies | Visual Basic for Applications
Issue on VBA MSAccess execute command
Dear Support, I have used for a long the below VBA code run from an excel file to insert the content of one table from one MSAccess DB to a different table placed in a different MSAccess DB placed in a different location: Private Sub…
Developer technologies | Visual Basic for Applications
Has any Code to Connect to the Server Hostname and get data
So new try my MySQL connection will not work the way i want to be so another question here now Its possible to connect to the hostname and get any database information and show on the Winform like this shows on datalist, listview or another …
Developer technologies | Visual Basic for Applications
one question pissble in future to this this
Hi there microsoft its possible to new future to add html files inside a script or class file and use on the form like use on browser i have this file here made in html accordion and i would like to use on the winforms and load data from database …