Visual Basic for Applications; a subset of Visual Basic used in all Microsoft Office applications. Consider using this tag together with the tag for the specific application in question.

learn more… | top users | synonyms

1
vote
0answers
11 views

shift data down in one sheet when a new value is entered in a different sheet

I've reached a point where I'm quite sure I need VBA but I don't know VBA so I need your help. So: I have a worksheet for organizing data on certain ceramic products. In my main sheet (called ...
0
votes
0answers
5 views

My Excel Macro book crash after enable content

I have number of macro workbook. when I open it on VDI network and click on enable content Excel crashes, and I am not able to work. But when I open this workbook on Laptop it works fine. VDI ...
0
votes
0answers
9 views

Excel 2013 XY Scatter and the label issues - something more complicated / VBA

I have a scientific machine passing values from different sensors in an Excel Worksheet including a time stamp. To have all values compared at once, I created a chart having multiple y-axes, so each ...
0
votes
1answer
10 views

Hide user form on non active workbook?

I have a user form that when a workbook is opened, will show a user form with command buttons. I want to be able to open another workbook and not see that userform on the other workbook. I only want ...
0
votes
2answers
23 views

Excel - How to return the first number only string that is between 7-10 characters long in a large body of text? (preferably Formulas only)

I'm trying to extract some numbers from a few cells that each have a large body of text. The number strings are accompanied by certain words that precede the number string I'm trying to extract. ...
-3
votes
1answer
19 views

How can I delete duplicates in one column, based on dates in a second column?

There may be no duplicates in column A, there may be many. Column C contains creation dates and I want to delete all rows except the most recent. If it can be done in VBA that would be good, otherwise ...
1
vote
3answers
23 views

How to combine values from multiple rows into a single row? Have a module, but need the variables explaining

I'm completely new to VBA and trying to implement the excellent looking solution here by Raystafarian How to combine values from multiple rows into a single row in Excel? (the revisited version). ...
0
votes
1answer
22 views

Keep command button visible while scrolling down worksheet?

Is there anyway to keep a command button visible and while you are scolling down a long worksheet, you can still see the button scroll with your worksheet? I know there is the freeze pane but I would ...
0
votes
0answers
32 views

How do I make form fill out to different sheets based on the month?

I have an exercise and diet log that I fill out every other day and I want the data to move to another sheet. Sheet 1 looks like a worksheet and I want it to move (I think the best way to do this is ...
-2
votes
0answers
23 views

Excel 2010 and VBA

I'm having trouble setting up a VBA script to successfully run in Excel 2010 page set-up. I was hoping to automate adding a repetitive Header Title, top right page x of x, and LFooter stacked ...
-3
votes
0answers
22 views

How to create a macro that pulls data into one summary sheet from multiple sheets? [on hold]

How do I create a macro that pulls data into one summary sheet from multiple sheets? I need the macro to filter on one column (the status column) in every sheet, and not bring over the rows that have ...
-1
votes
0answers
18 views

VBA code to hide rows when 2 columns both have the value 0 [on hold]

Good day, I please enquire about VBA coding in order to hide rows if two adjacent columns (columns G & J) BOTH has the value 0 in them. Rows should stay unhidden if either column has a value in ...
-1
votes
0answers
24 views

Java Installer crashing when accessing VBA code

I work usually with DDE Excel. I have two computers, one with Windows XP and another with Windows 10 64 Bit. The problem happens with the latter computer. I connect the computer with provider DDE ...
-2
votes
0answers
36 views

Compare two Columns and delete the gap Using Macro

I have an Excel file and i want to compare the date in columns A and D and delete the gap between them. For example based on this picture: Time in column A start at 15:25:15 and in D at 15:23:52. ...
0
votes
1answer
23 views

How do I identify partial duplicates in an excel list?

I have a list of over 1000 company names, however some are duplicated but they aren't exact duplicates (ie: Nintendo, Nintendo Inc, Nintendo Video games, etc), is there a way to identify the ...
0
votes
0answers
16 views

How do I accept tracking changes for a specific symbols and reject for the rest of the text?

I would like to accept tracked change only for specific symbols like manual line break and break section and reject any other changes. How can I proceed? I guess it should be a macros which looks for ...
0
votes
1answer
26 views

Check cell value for active conditioning format being applied?

Is there a way to check if a range of cells have a certain conditioning format on them such as cell is highlighted if blah blah blah... ?
-1
votes
0answers
12 views

Why macro template is not working using my log in but works perfectly using my colleague's log in?

Could you please advise on this? Macro is working perfectly fine using my colleague's log in but whenever I log in and try to run the macro template, macro didn't finish generating the report. When I ...
0
votes
1answer
38 views

How to disable right click “delete” option on worksheets tab

Is there a way to disable the right click "delete" option on the excel worksheets tab at the bottom to prevent users from be able to delete a worksheet. I know that protecting the worksheet/workbook ...
-1
votes
0answers
14 views

Setting public variables for parameters in a report in Micreooft Access 2007 VBA

I have a database in Microsoft Access. There is a year-to-date report brought up by a form which sets the parameters for the report with public variables. This report worked in earlier an version of ...
-1
votes
0answers
19 views

Search function based off a price in VBA and Excel database

I have a database of computer parts in excel and I am trying to display recommended parts based off of the price that the user inputs or if price is not an issue the best possible (most expensive) ...
3
votes
3answers
103 views

remove leading 0 in front of decimal except when a a non-zero number precedes it

I have a column, which has a comma separated values inside each cell that look like this 0.1, 0.2,0.3, 0.4,0.5, 0.8,1.0 1.5, 1.6,2.0, 10.6,10.9, 15.2,30.75 20, 0.25,280.2, 0.29,300.2, 423,530.76 ...
0
votes
1answer
24 views

How to run Sub with parameter in Excel VBA?

I have procedure in Excel VBA which is need range parameter and also will produce output range exactly in active cell. The code looks like this : Sub test(oSource as Range) Dim oTarget As Range ...
0
votes
0answers
17 views

How to autofill content controls based on a seperate dropdown list in Word?

I have a form with multiple fields. Three of these fields are dependent on the selection chosen in a dropdown list at the top of the form. For example: if Location = New York City, then the ...
0
votes
1answer
14 views

Hardwareinventory - Copy Record with values in Access 2016 Web App

I want to make a WebApp in Access which help me inventory all our Hardware. Below is a VERY wip ERM for the Database behind it. Every CPU-Object is its owm physical thing (if we have 2x i5-3450 there ...
0
votes
1answer
44 views

add space after nth commas in Excel, Notepad++, or emEditor?

Notepad++ 6.8.8 I want to be able to turn several lines that start like this: 0,2,3,45,67,89,01,234,567,890,123,4567,8901 0,7,8,9,0,11,12,13,14,151,162,173,184 x,z,q,r,n,f,t,a,e,f,z,n,a into 0, ...
0
votes
1answer
44 views

Excel If formula to vba

I have this formula which checks a cell to see if its a 6,2,a, or b, in which case the word cash is written. ...
0
votes
1answer
27 views

Formula or VBA for cell formatting using value based on a cell but formatting from an other cell

I have a fixed set of values, (0%,20%,40%,60%,80% and 100%) in column E. If I fill a cell in column E with any of the above values, the cell G should pick formatting from another cell. For example, ...
-4
votes
0answers
22 views

Nothing to ask so this has been deleted [duplicate]

..............................................................................
-1
votes
0answers
22 views

Nothing to ask this time. This can be deleted [duplicate]

................................................................................................................................................................
-2
votes
0answers
27 views

VBA code internet explorer [migrated]

I need to select multiple value in ENV Type and ENV Class and Device type..post submitting <td class="dtl1c">Env Type:</td> <td align="left" class="dtl1c"><select ...
0
votes
1answer
226 views

PC unable to find EXP_PDF.DLL

I have an Excel workbook that uses VBA to create PDFs from sheets, and send them via email through Outlook. When I click the button to create the PDFs and send, Microsoft Visual Basic gives me the ...
0
votes
2answers
20 views

Custom formula for databars in Excel

How would one go about using a custom formula to determine the format conditions for databars? Meaning, in Excel under "Conditional Formatting" there's a format called "Data Bars". However, you ...
0
votes
1answer
35 views

Emails replied to by VBA script do not show reply icon with purple arrow

I have a VBA script that moves an email to a folder (dialog box) and generates a reply that will be saved in the same folder. The problem I am having is the original email never shows the reply icon ...
0
votes
1answer
72 views

Same Bookmark for Multiple Locations MS-Word

I am feeding Excel data into a Word document with Excel VBA. When doing this, I have many bookmarks in Word. Sometimes I need to pull the same value from Excel and feed it to multiple bookmarks in the ...
-1
votes
1answer
17 views

How do I solve “runtime error type 13 Type mismatch” in excel VBA when clearing contents?

I have some VBA code that clears contents from several cells. Most of those cells have data validation so that a value must be selected from a list of options (yes, no, NA), the rest are open for any ...
0
votes
0answers
11 views

Create a calculated field in Outlook to be used in views

I know how to use VBA to create a user defined field for a folder. Is there anyway I can create a user defined calculated field that is global that I can use in views? I want it global so I don't ...
0
votes
2answers
11 views

Looping through two column to check for condition

I want to loop through column P and see if there is a cell that has the number "1" in it then at the same time loop through column N to see if there is also a number "1" at same row/column, if there ...
0
votes
1answer
45 views

Check excel cell if font is a certain color?

I want to use vba to check if the text in a cell in excel is of a certain color, lets say red. Any ideas?
0
votes
0answers
27 views

Excel, worksheet scrollbar size

I have a problem with the vertical scrollbar on one of my worksheets. The worksheet contains ~20000 rows and the scrollbar is too big to use conveniently. However when I click and drag it, it ...
0
votes
2answers
37 views

Excel VBA incrementing columns

I am trying to combine multiple columns of varying lengths into 1 column on another sheet to allow for vlookups off this column. I am able to increment down through the first column easily, but I am ...
-1
votes
0answers
37 views

Excel: Check if cell string value exists in column, and get all cell references to that string

i need a code that can search the values that exist in column A,from column B, if it exist return the value in column C EX : Column A Column B Column C Pant ...
0
votes
0answers
14 views

In MS Access VBA Designer window all menus, ribbons and tootlbars are missing

The missing items make it impossible to use. Code can be written, but not executed and tested.I have tried many solutions, most of which are to restart the VBE, but that does not work. In fact, none ...
0
votes
2answers
27 views

VBA query - adapting existing code

I've found a bit of VBA which is helping me do what I want to do, which includes the following: With ThisWorkbook.Sheets(TargetSh) NxtEmptyRw = .Cells(65536, 1).End(xlUp).Row + 1 .Cells(NxtEmptyRw, ...
-4
votes
0answers
29 views

How to display VBA message only once

I found some VBA code online, which I am using in Excel 2013. A message pops up every time I enter data into another cell. How can I make the message display only once? Private Sub ...
0
votes
1answer
27 views

#NAME? on UDF that previously worked

I created a VBA function: Function LOJA(x As String) Dim a As Integer Dim f As String Dim f2 As String Dim f3 As String a = InStr(1, x, "-") f = Right(x, Len(x) - a) a = InStr(1, f, "-") f2 = ...
-2
votes
0answers
34 views

ActiveX 'Command Button' causes Excel 2016 to crash?

This problem has started occurring recently, although I've had no issues in the past. I have not updated or otherwise changed the program environment. I have several 'Command Buttons' (a type of ...
0
votes
1answer
32 views

Change name box of a image inserted into excel worksheet

When you insert a picture into a excel worksheet, you get automatically Picture 1, Picture 2, and so forth...... I have a function when a picture is selected to put black border around it. Problem is, ...
0
votes
0answers
22 views

Excel 2007 Unprotect Sheet prompt in password protected sheets on Windows 7 machines

Windows 7 users of software I created in Excel get an "Unprotect Sheet" prompt when clicking on any sheet or cell in a sheet that is password protected. They hit cancel, sometimes several times and ...
1
vote
1answer
43 views

MSWORD VBA close document on save

I am trying to get a document to close when saved, using VBA. I have searched for this extensively but mostly it comes up with people trying to not turn off saving when closing a document. What I ...