Visual Basic for Applications (VBA) is an event-driven, object-oriented programming language for writing macros, used for the entire Office suite as well as other applications. VBA is not equivalent to VB.NET, or VBS; if you're working in Visual Studio use [vb.net]. If your question is specifically ...

0
votes
1answer
5 views

Finding values from another worksheet (a loop in a loop)

I would like to atomatize an excel process using VBA.The script has to go cell by cell in a selected area on Sheet3. Each cell contains a number or is blank. The script will go and search for the ...
0
votes
0answers
12 views

MsgBox code not working in Excel VBA

In Macros, on my device, when I enter "MsgBox" with some number or text, as soon as I move to next line it automatically changes to "msgbox" and when executed it starts giving an error at this line. ...
0
votes
2answers
18 views

VBA Excel 2011 : Compile error : Method or data member not found - simple form

I am a beginner in VBA and I tried to inspire me from https://www.excel-easy.com/vba/userform.html to make a simple userform and fill a Sheet.Here the VBA code of userform (called Formulaire1) :...
-1
votes
3answers
24 views

using VBA, how to remove the addidtional repeated characters at last

I have multiple rows, I need to join with "@#" characters at end of every cell value, I am able add this characters but at the end it is printing extra characters(@#)My excel file: From this excel ...
1
vote
1answer
34 views

Extract data from PDF to Excel

I have the following VBA for copying PDF data to an Excel sheet, using Word to convert that data:Private Sub CommandButton3_Click() '(load pdf)Dim o As VariantSet appWord=CreateObject("...
1
vote
1answer
24 views

On Error GoTo optimization VBA

Sub ComName_Click()Dim objOL As ObjectDim objMail As ObjectOn Error GoTo 1Set objOL=CreateObject("Outlook.Application")Set objMail=objOL.CreateItem(0)With ...
0
votes
1answer
11 views

How to add sheet names containing a specific string to a user form combo box

I am attempting to write code that cycles through all the worksheets in my current excel, and if the worksheet name contains the word "Pack" it is added to my userform combobox. My code is not ...
0
votes
0answers
34 views

Loop through each cell in a data range and add the value in excel

I have a data range and i want to loop through each cell and add the value of the cell in excel. I tried below code but it keeps pulling me the first cell value in the excel. Below is my codeDim ...
0
votes
2answers
15 views

MS ACESS :restrict numbers of rows in ms access query

I have two tables i want to select some specific numbers of records from table 1.the count of records must be equal to value mention in table 2.Table 1Table 2Number of records in output must be ...
0
votes
1answer
33 views

VBA Autorange function for Array to Range in excel

As I am working with large csv files, I decided to load them into VBA memory instead of loading in my spreadsheet to make it quicker and lighter. So I have a function CSVtoArray that read through my ...
0
votes
2answers
16 views

Transform Query in Access VBA

I have written a VBA code in Access. But, I received syntax error in TRANSFORM statement. I would be grateful if you could help me.Sub TransformX1()Dim dbs As DatabaseDim strSQL As String...
0
votes
1answer
30 views

VBA help to include an if statement then ignore in my current VBA code

Really need help to rewrite the existing code I have to include an if statement. The VBA code creates and renames my tabs based on the data in column A in the worksheet "paste L3 here".I need the ...
0
votes
1answer
33 views

excel vba How to get a whole column range from a column number?

I can't think of an easier way to do thisCurrently converting a column number to a letter with:col_letter=Split(Cells(1, X).Address, "$")(1)Then I'm defining an entire column range like so:....
0
votes
1answer
17 views

Outlook Print handling

I'm trying to solve a problem with saving logs of printed mails. Unfortunately there is no event as in word or excel like "BeforePrint" or "AfterPrint". Can someone support me by an idea, how can i ...
-1
votes
1answer
25 views

VBA: Interrupt double click (two single clicks)

ScenarioI have an excel worksheet where I am using a certain cell (say C3) as a button functionality: Whenever the cell is selected, a certain function is executed.In order to be able to click the ...

153050per page
angop.ao, elkhabar.com, noa.al, afghanpaper.com, bbc.com, time.com, cdc.gov, nih.gov, xnxx.com, github.com,