Visual Basic for Applications (VBA) is an event-driven, object-oriented programming language for writing macros, used for the entire Office suite. If your question is specifically about programming Excel, Access, Word or Outlook, use the appropriate tag: excel-vba, access-vba, word-vba or ...
0
votes
0answers
3 views
How to get a table to refresh in a Tab Control
I have a tabbed control with two tabs, one called add and the other called delete, I have a table in a form on the delete tab showing all the added records but how do I get this table to refresh when ...
0
votes
0answers
8 views
How to select data from a filtered column to use in another worksheet (function)
I have the following datas in Sheet1:
OddsId Play Type Sports OUD point AE Point
1 UDP Soccer
2 UDP Soccer
3 UDP ...
0
votes
0answers
11 views
check if a folder is open (vba)
I am trying to check whether a specific folder is open or not using VBA . I have found this code:
Sub test1()
Dim OpenFold As Variant
Dim oShell As Object
Dim Wnd As Object
Dim strFolder
OpenFold = ...
0
votes
0answers
6 views
Change range of activechart
everyone.
I am doing some vba code for chart right now. So basiccaly what I want is to use a variable to control the range of the data in the chart (Ther chart has alr been created with correct ...
0
votes
1answer
25 views
Error 13 Type Mismatch
I'm unable to work out why I'm getting an Error 13 with the following code - more specifically at line 8 (dStDev = Round(Application.StDev(rngGrainSummary), 3))
Dim i As Long ...
0
votes
1answer
26 views
VBA Write new file to Program Files folder
i have an xlsm file which is being used by a lot of users, i added an update function which needs to check on a server if a new update of the xlsm file is available, and if its available it needs to ...
0
votes
1answer
27 views
Invalid Qualifier - When trying to Fire Checkbox click
I assigned a macro to my checkbox, so that when you tick it, it sets a certain value into a cell. I however get a invalid qualifier error on my first Checkbox1.value.
Here's the code:
Option ...
0
votes
1answer
42 views
Comparing Variable in VBA
I am looking for a method of comparing two string variables in VBA. The current statement I am using (which is not producing the desired result) is:
If Variable1 = Variable2 Then...
I have a VBA ...
0
votes
1answer
14 views
VBA Copy & pasting adjacent columns of multiple rows
I wrote a simple macro to Copy and paste one row of two adjacent columns,I then added the app.ontime to automatically run the copy&paste macro. I have multiple rows of data I want to apply my ...
0
votes
1answer
11 views
Is there a way to put bounds on Goal Seek? If not, how would you go about this?
I'm trying to minimize the value of the sum of the residuals squared by varying the value of De, which is found in F1. I want the values of CFL Calculated to be as close as possible to the values of ...
0
votes
1answer
14 views
Excel macro is resetting column formats
I am copying some data from Access to Excel, using an Excel macro. It is working fine, except that some of the column formats are being changed in the process. The section of code that fills in the ...
0
votes
0answers
18 views
Comparing Two Columns in Excel Row By Row?
have currently browsed the forums and have came up with a code to compare two columns from two separate excel books and then highlight anything matching with the CompareRange. Here is a few more ...
0
votes
0answers
8 views
Auto-refreshing powerpivot for excel 2010 using VBA / Macros
I need to build a button in either VBA or Macro to auto-refresh an excel 2010 workbook using powerpivot data. Anyone know how to go about doing it? Nothing I've tried has seemed to work, and a handful ...
0
votes
1answer
15 views
Pass clicked cell value to excel function
I'm looking for a way to pass the current value of a cell at the time that the cell is clicked to a function as as an argument of that function. Or if there is anyway to access the cell value from the ...
0
votes
1answer
13 views
MS Access 2007 add logo to all forms
I am wanting to add a logo to all my forms/reports etc. I want to either store the image once in the database, even in the front end is okay, or I want to access a picture on the network/local ...
