An implementation of Visual Basic that is built into Microsoft products.
Visual Basic syntax question
Using Visual Basic programming language, how do I determine the row and column numbers of the active cell?
Developer technologies | Visual Basic for Applications
Problems with error trapping using Excel macros (Visual Basic coding)
I am developing an Excel macro and am having trouble with error trapping. Here is the actual code I am using: 'Select Name Tab On Error GoTo NEXTA Sheets(Name).Select GoTo NEXTB NEXTA: Call Add_A_Name(Name, EnvNo) NEXTB: On Error GoTo…
Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.
Trying to understand the basic syntax for Visual Basic for Word.
What does the text vb stand for before some commands?
Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.
how to disassociate vba code from onedrive?
modle1 attempts to: ChDir "C:\Users\sthom\OneDrive\Wordle." i don't have a onedrive account. this code, which i did not write, causes my vba code to hang up while fixing errors in my code. to overcome this hang up i need to save and reload the…
Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.
Fonte Size of VBA window
The font size of my VBA window are just enormous, i just can't solve this problem, can someone please tell me how do i fix this quickly?
Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.
TarunVBA2026PB20
frmProgress Option Explicit Private Sub UserForm_Initialize() '---------------------------------------- ' FORM INITIAL SETTINGS '---------------------------------------- Me.Caption = "Processing... 0%" 'White background / full…
Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.
Run-time error "53" window pop out when I use WORD
Why is there a window pop out saying Visual Basic for Application, Run-time error "53" when I open WORD.Ru
Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.
How to write VBA so that it automatically runs to get data from the source file
Hello I want to write the VBA so that the following Lamda function wroks fetching the data from other folders. Soruce data is in different folder name and sheet which will change all the time (example: : \1_DB_Collectives\DB Collective_1,2,3, etc) …
Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.
Problem with "Action will reset your project, proceed anyway"
I have created a vba program. Now, when I try to run it, I get a "This action will reset your project, procede anyway?"; all of my code has been selected. If I click "OK", all of my code in this particular module is deleted. I can…
Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.
How do fix error ToInt32 is not a member of Convert.
GitHub Copilot suggested some code improvements but one suggested line produces the error above. Code: If countObj IsNot Nothing AndAlso Convert.ToInt32(countObj) > 0 Then
Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.
EXCEL VBA: Is it possible to use the Filter function in VBA to filter more than 1 search string?
Hello, I sometimes use the Filter function to filter a 1-dimensional array. The syntax is: Filter(sourcearray, match, [ include, [ compare ]]) The "match" argument is used to search the string we want. It seems that we can only search…
Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.
Sono spariti gli optionButton e CheckBox dal VBA!
Nel progetto di una userform nell'inserire OptionButton e CheckBox questi appaiono solo con la Caption ma la forma non c'è più! come posso risolvere?
Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.
Excel VBA Setting Application.ScreenUpdating Not Setting New State
To the Community: Suddenly having an issue with the Excel VBA ScreenUpdating Method where setting the state to 'False' results in no change of state, despite the value data-type being assigned. I have seen a number of postings regarding this with…
Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.
Address in, GPS coordinates returned; GPS coordinates in, address returned
I am looking for Visual Basic code or a Visual Studio control that can accept a world-wide mailing address as input, and return GPS coordinates. I am looking for Visual Basic code or a Visual Studio control that can accept GPS coordinates as input, and…
Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.
VBA Excel - Getting the ActiveWorkbooks.Name that is having spaces
Hi, I have an Excel file (Archives_Years.xlsm) with a few sheets by years that I want to fill with some content of other files (excel or text files) that I am opening one by one in Excel (I have to adapt the VBA code depending of the file). In my…
Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.
Run time error 9, Subscript out of range eroor is showing while using Excel VBA
Run time error 9, Subscript out of range error is showing while using Excel VBA, When i am using Excel VBA and write coding for run a macro and when i run the code this error is showing, I tried every thing to solve this, but not working, I am unable to…
Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.
Visual Basic in Excel Instruction and function manual
I am having trouble finding basic information on instructions with detailed syntactical rules and similarly a list of functions in Visual Basic. EG... where do I find the exact syntax for dimensioning an array and declaring a range of cells as an…
Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.
VBA control on worksheet calculations
I woud like to have VBA control over when a work sheet is calculated
Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.
Need to figure out how to create drop down list in Powerpoint using developer option
I've watched the few videos and read articles I can find on this topic but still cannot figure out how to create a drop down list in powerpoint, using developer option. When I get to the point of entering my data in the code field: End…
Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.
VBA trying to launch Outlook 2016
My VBA Excel code is set to send an email, but rather than using the existing Outlook on my laptop is trying to launch and install Outlook 2016
Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.