Questions tagged [visual-basic]
Visual Basic is a programming language and accompanying IDE (integrated development environment) from Microsoft. A successor to the BASIC family of programming languages, it focused on ease of use and rapid application development. Support for it ended in 2008 and it has since been succeeded by Visual Basic .NET, a fully object-oriented programming language based on the .NET framework.
101
questions
0
votes
1
answer
27
views
Is it possible to have bidirectional relationships in Microsoft Access?
I have a database including two tables for suppliers and people:
the suppliers table has a look up column where one can select the people relevant to that supplier from the people table. and there is ...
- 546
0
votes
0
answers
21
views
Changing the cell height and cell width of multiple tables MS Word 365
I have a MS Word Document which has over 100 tables. I want to change the cell width to be 0.54" and cell height to be 0.56" but I want to do them all at once but I don't know how to do it.
...
0
votes
2
answers
115
views
Insert URLs in plaintext after each hyperlink in MS Word using VBA
I would like to automatically insert the URL for each hyperlink in a word document beside the linked text.
For example instead of having:
my hyperlinked text
It should be:
my hyperlinked text (https://...
0
votes
1
answer
393
views
How to format Excel cells selectively by character
I have the following Excel cells:
What I want to do is to format every cell that contains letters D and E with bold and red colors. How can I achieve that?
In the above example I only format the ...
- 103
0
votes
1
answer
209
views
Excel VBA: Flipping cells horizontally along with their formatting
I am trying to write a code which will flip my cells horizontally via Virtual Basic along with cells formatting (I need background colour to flip too).
What I mean by flip is this:
I came with the ...
- 534
1
vote
2
answers
579
views
Creating a Word macro to type increasing numbers
I'm a Youtuber, and I frequently create word documents that mark where I would like to insert images, videos, or sound bites, corresponding with certain words in the script, to illustrate the points I'...
- 11
1
vote
1
answer
102
views
Excel 2 way linkage in different sheets and different range
I'm trying to link 2 range of cells in a 2 way link. Meaning, if you change a value in a cell it changing the value on other cell and vice-versa.
For reference:
Excel: 2-way linkages for cells on both ...
- 11
1
vote
1
answer
2k
views
Need help to create a loop to copy and paste data in a certain way
I am struggling with a loop from past 3 days, finally requesting help from the community.
I want to each cell in column M from (input sheet) to output sheet in column BE multiple times based on the ...
- 11
1
vote
2
answers
466
views
Mirror a group of cells elsewhere in the same sheet
I am trying to have an interactive table multiple places in my sheet to prevent my users from having to scroll repetitively through this massive sheet. every time this table is updated from any of the ...
- 11
-1
votes
1
answer
52
views
Find location of last clicked hyperlink programmatically
I am in need to find the location (i.e. cell and spreadsheet within the same xlsx file) of the last clicked hyperlink, being in another spreadsheet called by the hyperlink itself.
The reason is that ...
- 1
0
votes
0
answers
1k
views
How do I change text color on a single word when cell changes?
Please see attached photo:
In case the photo is not there:
Line 35 shows Text in all red color.
Line 36 shows Text in all black but one word is red color.
Default Setting: Red text on a single word.
I ...
- 15
0
votes
1
answer
376
views
Outlook VBA - A startup macro that moves incoming undeliverable (NDR class) messages for multiple shared inboxes
I have a little experience in Java but barely any in Visual Basic. I need to create a macro for my work Outlook that has 4 inboxes in the profile. One is my [email protected], another is for marketing@abc....
- 1
0
votes
1
answer
259
views
Excel Formulas for Assessing Comissions (Additions) and Omissions (Deletions) in Qualitative Data
I was hoping someone might be able to figure out some formulas (or VBA scripts) for me to help me calculate qualitative analyses. Specifically, I have two columns that look like this:
Participant IDs ...
0
votes
1
answer
2k
views
Make an Image Full Screen
I have a bunch of TVs that are used for digital signage powered by intel nucs running windows 10. I am currently using a Visual Basic Script that works okay but was wondering if there is a better way ...
0
votes
1
answer
87
views
Populating Data from a Column Multiple Times in Excel
I currently have a spreadsheet that contains a repeating set of data in specific columns with one field in each row being blank, such as the following:
I also have a column of numbers I wish to have ...
1
vote
3
answers
814
views
What's the VB code for auto-sorting a range of data based on a text value in Excel?
I have a few columns, important among them being: Tasks, Priority, Status.
I want all rows of records where the priority says "High" to automatically update themselves and appear on the top of other ...
- 125
0
votes
1
answer
334
views
Visual Studio: how to disable smart tags in Visual Studio (or change its underline color)?
How to disable smart tags in Visual Studio (2013 Community / Basic)?
If it is impossible, how can I change the underline color (for example from red to white)?
I mean about 'smart tags' the feature ...
- 1
0
votes
0
answers
296
views
Visual Studio 2019 Intellisense color-coding / toolbox not working
I have just downloaded Visual Studio 2019 on my Mac and I'm having problems with visual Basic.
Visual Studio doesn't color the code that's always white (in my case, for Visual Basic), and also, I can'...
- 1
1
vote
2
answers
298
views
Excel VBA - Scoping Const Variable to be Accessed only by Current Project
I have an Excel Add-in for storage of UDF's as well as a personal workbook for storage of subroutines.
Inside of the Add-in, I have a module for constants, where I have an entry for ideal gas ...
- 113
1
vote
1
answer
1k
views
How to use Excel to calculate concurrent streaks
I want to use Excel to calculate the "best" and "current" streak in a range of data.
Say that a shop's sales target for the day is 500. I have a column which contains the daily sales data for the ...
- 13
0
votes
1
answer
410
views
What does the "Stop script after..." option in WScript's GUI settings actually do?
My understanding is that all of the various .vbs apps are running against wscript.exe
I had reason to experiment with a few .vbs scripts, then wanted to manage the running scripts (e.g., list them, ...
- 379
0
votes
1
answer
123
views
Hotel software opens E-Mail Window in Outlook with generated text - how to change it automaticly to html or trigger a vba script?
My situation: A hotel managment software generates a text and opens a "New E-Mail" Window in Outlook with that text preset. However, I need the E-Mail to be in HTML format, apply some formatting and ...
- 182
1
vote
1
answer
518
views
How to verify information is entered in cell only if adjacent cell is not blank. Excel VBA
I have two columns, one(B) with a name and the other (A) with a number. I am trying to make it so an error message will prevent me from closing excel if cells in column A are blank but the adjacent ...
- 13
0
votes
1
answer
680
views
Strange Error with ntdll.dll Windows 7 Ultimate x64 SP1
WINDOWS 7 ULTIMATE X64 SP1
I have recently been trying out a (shareware) clipboard management program called Spartan, which comes loaded with heaps of clever and useful features, but it does seem to ...
1
vote
1
answer
11k
views
Visual Basic 6 on Windows 10 (Yes, Really)
Is there any way to install VB6 on a Windows 10 machine?
I've been asked to revive and move an old company application from an XP machine to a new PC. The code is going to be rewritten in C#, but we ...
- 11
1
vote
0
answers
64
views
Is there a way to check if a formula's result has changed?
I'm trying to figure out how to sort an Excel spreadsheet after part of the row is filled out. The last cell in a row is a formula to total up some of the other rows. The condition I was thinking ...
1
vote
2
answers
8k
views
Visual Basic - VBA code to skip or ignore rule if cell contains certain value
I have written the following VBA code to automatically populate column "P" with "pending", "Not due","-" based on the value of column "O".
The user will manually have to enter "complete" into column "...
- 11
1
vote
0
answers
127
views
My requirement is to copy a content from excel, open terminal app, paste the copied content in terminal and execute
I am new to VB - So please guide me [Currently Terminal is opening up, but the focus still remains in excel. I want to paste a copied value in terminal app. guide me guys]. I am using Excel for mac ...
- 11
1
vote
1
answer
54
views
Convert String to Size | Visual Basic
Using vb.
I'm trying to use the text of a combobox as the value of my font size.
Means, as a user, I can choose which font size I'd like to have by clicking it out of the dropdown menu.
Dropdown menu:...
- 315
0
votes
2
answers
2k
views
Execute Powershell Script from a EXE... Executionpolicy RemoteSigend/Unrestricted, still failing
So i wrote a small VB Program, which runs a powershell script.
I know that my ExecutionPolicy has to be set on RemoteSigned or Unrestricted in order to execute scripts on my Computer.
So that's what ...
- 315
1
vote
1
answer
375
views
Export Outlook Exchange folders to windows file system
Currently using A VB macro to pull folders of emails to the windows file system but it isn't able to pull folders stored on an exchange server, Is this even possible? Using the VB script below
' SET ...
- 13
1
vote
1
answer
14k
views
How to automatically import data from csv file and append to existing Excel table
I have a .csv file and a master excel file. The master file contains a table and I would like to automatically append the data in the .csv file to the existing table. The data has the same headers and ...
- 21
1
vote
2
answers
644
views
How can I animate a "systems thinking" diagram like this example?
I like this javascript based version of a systems thinking diagramming tool. It takes relationships and calculates the values behind it, then animates a dot along the path.
So before I get further, ...
- 2,265
0
votes
1
answer
75
views
In Excel, how to create a VBA that returns a data range from another sheet when data validation = to a certain choice?
I'm trying to return data (from A1:D14) on sheet 4 into A2:D:15 on sheet 1 when I select "A" on my data validation list located on Sheet 1 cell A1.
0
votes
1
answer
1k
views
In Excel, Sum hierarchical data based on existence of subdata
I have a set of rows like this that display some hierarchical data.
A | B | C | D | E | F
1 Task | | 1 | | 2 |
2 Task | | 1 | | 2 |
3 Task | | | ...
- 213
0
votes
1
answer
421
views
More efficient way of creating an array of months & revenue metrics?
I am relatively new to VBA and had a question about defining arrays.
I am writing a function in Microsoft Access to project five revenue metrics for the rest of year based on the most recent month's ...
- 3
0
votes
1
answer
92
views
Problems with VB Script
A while back I posted a question asking for a VB script to delete a shortcut "TeamViewer 12 Host" from anyone's and everyone's desktop if it existed. Local not remote. I ran it on my Windows 10 ...
- 107
0
votes
0
answers
69
views
Visual Basic C++ and Visual Studio Install Problems
my PC has some problems. When I install Visual Studio or Visual Basic, I have to kill dllhost (First problem) to bypass system restore, as I corrupted system restore and pretty much the whole ...
- 313
1
vote
1
answer
1k
views
MS Word VBA Error: "The item with the specified name wasn't found"
I'm trying to set up a macro to adjust the field code of cross-referenced items so that only the numbers show, e.g. 3 instead of Figure 3.
I've found online that \# "0" can be added to the field ...
- 11
0
votes
0
answers
200
views
Microsoft patch : KB3203859 and KB3196718 throwing run time error for Visual Basic application
We have a windows server 2003 VDM, in which VB applications are throwing
this run time error:
However after uninstalling KB3203859 and KB3196718 Microsoft patches, the run time error is gone. I tried ...
0
votes
1
answer
31
views
Develop small shift worker schedule using If, than etc
I manage a small team of shift workers, 2 full time and 3 who fill in on shifts that can't be covered.
For a small number of staff I seem to spend a lot of time figuring out schedules (there are ...
- 1
0
votes
2
answers
844
views
Visual Basic highlighting for Kate text editor
kate supports syntax highlighting for so many programming languages I was surprised when I couldn't find Visual Basic on the list.
How can I get Visual Basic highlighting on kate?
I know some ...
- 140
0
votes
1
answer
79
views
Is there a security risk when building an internet radio player in Visual Basic?
I have built a simpel internet radio player in Visual Basic. It contains a couple of buttons and a webbrowser. My firewall asks for permisson to access the internet. Is it safe to allow a homemade ...
- 31
0
votes
1
answer
715
views
Visual Basic - Import selected rows and columns from Excel
Is there a way to add more than one range of data from Excel to Visual Basic?
I have managed to import the cells A6 to B260 into a datagrid, but I also want the columns E6-E260 and G6-G260.
(...
- 31
-2
votes
1
answer
70
views
Automating a series of Microsoft Office tasks [closed]
I am currently doing a series of rather mechanistic tasks and hope to automate them so as to free up my time for other more productive purposes.
The series of tasks that I have to do looks something ...
2
votes
1
answer
221
views
How can I insert extra spaces to align code in the Visual Basic Editor?
I’d like to add spaces to align the “=” in this:
To get something that looks like the alignment of “As” in this:
When I try to add spaces to align the “=”s, the Visual Basic Editor removes them ...
- 121
1
vote
1
answer
90
views
Outlook 2013 Appointment through Visual Basic Excel; I want to have an appointment that my calendar says busy and others say free
I'm creating an Excel document with a number of different required settings to make the process of logging vacations and business trips in my company's division easier than the current system.
...
0
votes
0
answers
357
views
Visual Studio newbie need help making a VB front end to a PS script
I'm a system admin at work and part of the day to day is creating new mailboxes for users in Office 365 and we are forced to use powershell to do this. The only variable in the PS commands is the user'...
-1
votes
1
answer
125
views
Excel 2013 VBA script needed for [closed]
I have several cells that have a string of text that are partially Bold and partially NotBold. I need to delete the Bold portion of the Text in the Cells
Example:
lname1, [email protected]
...
- 13
1
vote
0
answers
645
views
Excel 2010 - Combine specific sheet in >200 separate files into single worksheet?
I have tried solutions in other posts like this and so far nothing has worked :/
I have >200 separate excel files, and essentially I would like a specific sheet from each of these files combined into ...
- 27