Skip to main content
Super User

Questions tagged [vba]

Ask Question

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. Good questions on VBA generally contain some code and asks for solution of specific issues. Questions asking for entire solutions (please give me the code / how to do this and this with VBA) are off topic and will be closed as too broad.

3,826 questions
Newest Active Bountied Unanswered
-3 votes
1 answer
87 views

I have a case, I am not sure if its possible to solve, but I will appreciate any help or some sort of workaround. I need to compare combination of data from columns A+B with combination of data from ...
Andon Key's user avatar
  • 71
0 votes
0 answers
43 views

I am doing a wildcard search in a MS Word document of 2 capital letters side by side in any word, but after the search I want to be able to select the complete word in which the 2 capital letters side ...
Y M's user avatar
  • 1
0 votes
2 answers
80 views

I have created some VBA applications. I miss the very easy high-level programming interface in a Linux system. E.g., I use LibreOffice Calc, and I am searching for a programming interface like VBA for ...
Gloster's user avatar
  • 81
0 votes
0 answers
38 views

I have many documents that are divided into 'chapters' using headings - I want to remove blank lines at the end of my heading 1 pages. I consider my chapters to be all the text following a Heading 1, ...
Ramses505's user avatar
  • 25
0 votes
2 answers
124 views

I am trying to match a combination of data from columns A and B with combination of data from columns C and D (example: row 2 A+B should match row 1 C+D [Week 33 444]). Also, would it be possible to ...
Andon Key's user avatar
  • 71
0 votes
1 answer
108 views

With the following macro I can add a date field with a date on a workday in the future (how far into the future is realised via a input box): Dim InputDays As Single: InputDays = InputBox("Due ...
Lukas's user avatar
  • 141
3 votes
1 answer
347 views

I know this is a fool's errand, and probably a bad idea, but just curious. Suppose I have a time tracking spreadsheet. When I open the spreadsheet, I put the time I started up Windows in a certain ...
Mark Stewart's user avatar
  • 343
2 votes
1 answer
261 views

I this Word file, I put 2 characters. I only detect these as '(' open braces using VBA. The Word editor also only shows the default style and font. I'm pretty sure these are Wingdings characters. Here'...
KungPhoo's user avatar
  • 121
1 vote
0 answers
61 views

I develop and maintain a number of shared Excel workbooks, all of which are stored on OneDrive and sync across six different computers. One of the biggest issues that I consistently run into is that ...
user avatar
0 votes
0 answers
36 views

I insert audio files on some of my slides. Each clip is intended to play over a number of slides. I have 2 VBA macros that check a presentation for overlapping or underlapping audio by looking at ...
ralphandtexas's user avatar
  • 1
2 votes
1 answer
144 views

I'm fairly beginner when it comes to Excel formulae, and I've been presented with a challenge I'm afraid is far beyond me. Attached is a snippet example of a very large table I'm working with. The ...
Austin Leavitt's user avatar
  • 23
0 votes
0 answers
78 views

I use MS Word for creating exams for my students. Each question is awarded a certain maximum points, which are written inside square parentheses/brackets, e.g.: Q1. What are the reactants in ...
arcticspace's user avatar
  • 1
2 votes
1 answer
522 views

I have a VBA function that takes 4 values in and does some calculations. The function works fine and I have tested it, but when trying to apply it at another location, it is treating 3 of the inputs ...
FTSU's user avatar
  • 21
0 votes
0 answers
68 views

I have searched high and low, and have found the only way to get input from a "closed file" is to use INDEX with a named range. This has worked perfectly for me. My next step, is to automate ...
Hany E's user avatar
  • 1
-2 votes
1 answer
188 views

As a newbie to VB and Excel I am having problem with the following: Cell A1 is being populated by a data feed and is frequently changing (every second) in value for each data event, both up and down e....
user2987634's user avatar
  • 11

15 30 50 per page
1
2 3 4 5
…
256