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.

Filter by
Sorted by
Tagged with
1 vote
1 answer
24 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'...
user avatar
1 vote
1 answer
31 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 ...
user avatar
1 vote
1 answer
450 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 ...
user avatar
1 vote
2 answers
119 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 ...
user avatar
-1 votes
1 answer
50 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 ...
user avatar
  • 1
0 votes
0 answers
531 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 ...
user avatar
  • 15
0 votes
1 answer
232 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 name@abc.net, another is for marketing@abc....
user avatar
  • 1
0 votes
1 answer
205 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 ...
user avatar
0 votes
1 answer
1k 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 ...
user avatar
0 votes
1 answer
44 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 ...
user avatar
1 vote
3 answers
597 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 ...
user avatar
0 votes
1 answer
182 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 ...
user avatar
  • 1
0 votes
0 answers
275 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'...
user avatar
1 vote
2 answers
155 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 ...
user avatar
1 vote
1 answer
953 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 ...
user avatar
  • 13
0 votes
1 answer
328 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, ...
user avatar
  • 379
0 votes
1 answer
106 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 ...
user avatar
  • 142
1 vote
1 answer
429 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 ...
user avatar
  • 13
0 votes
1 answer
639 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 ...
user avatar
1 vote
1 answer
10k 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 ...
user avatar
1 vote
0 answers
63 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 ...
user avatar
1 vote
2 answers
6k 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 "...
user avatar
  • 11
1 vote
0 answers
92 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 ...
user avatar
1 vote
1 answer
44 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:...
user avatar
  • 145
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 ...
user avatar
  • 145
1 vote
1 answer
343 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 ...
user avatar
1 vote
1 answer
13k 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 ...
user avatar
1 vote
2 answers
528 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, ...
user avatar
0 votes
1 answer
74 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.
user avatar
0 votes
1 answer
825 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 | | | ...
user avatar
0 votes
1 answer
226 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 ...
user avatar
0 votes
1 answer
88 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 ...
user avatar
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 ...
user avatar
  • 315
1 vote
1 answer
965 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 ...
user avatar
  • 11
0 votes
0 answers
193 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 ...
user avatar
0 votes
1 answer
27 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 ...
user avatar
  • 1
0 votes
2 answers
698 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 ...
user avatar
0 votes
1 answer
76 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 ...
user avatar
  • 31
0 votes
1 answer
687 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. (...
user avatar
  • 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 ...
user avatar
2 votes
1 answer
162 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 ...
user avatar
  • 121
1 vote
1 answer
87 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. ...
user avatar
0 votes
0 answers
328 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'...
user avatar
-1 votes
1 answer
121 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, fname1email1@email.com ...
user avatar
  • 13
1 vote
0 answers
635 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 ...
user avatar
0 votes
1 answer
46 views

How do I add one value to a variable every time a date field is null?

In Access 2013, I am working on a report. Using the On print event, I have a problem trying to add one value to a variable every time a date field is null. It works fine somaValores =Somavalores + 1 ...
user avatar
  • 57
0 votes
0 answers
56 views

View code in Excel - Import_Journals

I'm trying to look at some VB code in an Excel macro. This code is executed on a button click: Private Sub ImportSelected_Click() Call Import_Journals("SELECTED", "IMPORT") End Sub I want to see ...
user avatar
2 votes
2 answers
39k views

Install MDAC on Windows 10

I'm trying to install VB6 on Windows 10, I've successfully installed based on a tutorial site in portuguese [http://www.michaelrigo.com/2015/08/guia-definitivo-instalacao-operacao-vb6.html], and now ...
user avatar
1 vote
1 answer
140 views

Is programming in Visual Basic using Visual studio same as Visual studio enterprise?

Visual Basic is the language, is there a software with the same name? Also, in Visual Studio, you can create Visual Basic projects, but they look different than those created using Visual studio ...
user avatar
0 votes
0 answers
67 views

EXCEL: How can I use a custom function created in VB as formula for conditional formatting?

I created a VB script to validate a personal document from my country (just like the Social Security number in USA). It is BOOLEAN, receives the number as param and returns only TRUE or FALSE if it's ...
user avatar