VBA (Visual Basic for Applications) is the dominant programming language for Microsoft Office Applications [Word, Excel, Access...].
0
votes
0answers
7 views
Excel Mac VBA Loop Through Cells and reset some values
I currently have a worksheet that I have multiple people filling out every day. There are 4 columns that the users fill out: C, E, H, & J (all numerical values, one row per day of the month.)
...
0
votes
1answer
5 views
Simple IF statement excel vba
I have the following code below and what it does it create another excel document from the information gathered from the initial document (source). So what i want to do now is create a statement that ...
0
votes
0answers
7 views
Storing a worksheet name for use in another sub
I'm using one sub-procedure to store filepaths/workbooks and worksheets in Public variables which can then be accessed by other sub procedures in the module. Here is some example code:
Public myfp As ...
1
vote
1answer
12 views
Validate entered cell value according to a given data type
I use an Excel macro to create new workbooks filled with data of given csv files. One column is open to user input of certain attribute values. These values must fit a datatype and a certain ...
0
votes
1answer
8 views
Naming and referring to a chart in VBA
I am trying to create charts in excel using VBA . The code is as follows :
Sub testmacro()
Dim i As Integer
i = Sheets("Data").Range("M2").Value
Sheets("Email ID").Activate
...
0
votes
1answer
17 views
CSV into a another workbook in VBA
Updated question:
I would like to be able to have one .xlsm file put csv data into a second .xlsm file using VBA for Excel. The latter file is maybe open in multible computers. Below is a code behind ...
2
votes
3answers
27 views
Excel VBA - delete string content up to *word*
I'm trying to delete string content up to a certain word contained within the string. For example
"Emily has wild flowers. They are red and blue."
I'd like to use VBA in order to replace that with
...
0
votes
0answers
17 views
How to create an equation object in Excel with dynamic elements?
I use Excel sheets to calculate more or less complex equations. Now I want to create some nice looking equation object (non-linear) to visualize the calculations. Therefore it is necessary to replace ...
0
votes
1answer
20 views
VBA If Not Intersect not working for larger values on worksheet_change
I have the following code:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim btn As Button
Dim t As Range
Dim i As Integer
i = Target.Row
If Not Intersect(Target, Range("$B10:$B103")) ...
1
vote
1answer
16 views
Extract data from a two columned listbox to a sheet
I have a two-columned listbox, which I've manually added entries to using
.AddItem (potato)
.List(.ListCount - 1, 1) = bananaTbx.Text
When the user closes the userform all of the data is lost, so I ...
0
votes
0answers
20 views
Changing Named Range with manual calculation
I have a named range that changes during a macro operation.
For reasons of efficiency, I set the Application.Calculation = xlCalculationManual but the named range doesn´t change anymore.
Do you ...
1
vote
2answers
24 views
How do you take a vba addin and make an installer?
I have written a vba module that installs an addin button to excel. I would like to deploy it on many computers as easy as possible. Currently, these are my steps.
Save the excel as *.xlsm
Open the ...
0
votes
0answers
17 views
How to Find the confirm alert box popped up in a webpage and send keys to the alert box
I wrote VBA code to automate a web application but the problem is when few links are clicked the web page pops up an alert box and the VBA stops there(which does not allow the VBA code to run until ...
-2
votes
0answers
12 views
How to export data from different worksheets into and create several new workbooks to store them
I have a total of 40 Excel workbooks which contain 2600 worksheets each. Each sheet in every workbook contains only 4 data values in A1:D1.
I need to select some worksheets from each workbook and ...
0
votes
0answers
13 views
Launch Mailto in VBA 2007
Shell "mailto:[email protected]?subject=purpose&attachment=file:///c:/temp/test.htm", vbMaximizedFocus
I'm trying to use the below in VBA
...
