People who code: we want your input. Take the Survey

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
1answer
47 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 ...
0
votes
0answers
5 views

Has the System.Diagnostics.Debug namespace changed between .NET 4 and .NET 5? [migrated]

I'm trying out a simple VB program to use the System.Diagnostics.Debug.Writeline method in .NET 5. But when I run it nothing comes out on the output stream. I've used it before in .NET 4.7 and it ...
1
vote
2answers
35 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 ...
0
votes
0answers
19 views

How do I run a custom EXE in the foreground with icon in on Windows 10?

a company I work for has a custom EXE file they use for invoicing and database stuff, and was built using Visual Basic about 8 years ago! Unfortunately since moving to Windows 10 (I believe, it was ...
0
votes
0answers
25 views

is there any VBscript to remove single letters from entire column except the word

example: David A Horton after the vb script it will be like David Horton single letter like A will be deleted from entire column i tried this code Public Function CellSort(cellule As Range) As String ...
0
votes
0answers
20 views

How to open Windows form developed in Visual Studio 2019 in VB 2010 Express (.NET 4)?

Simple code and simple design. What's the easiest way to open it in a VB 2010 environment?
-1
votes
1answer
36 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 ...
0
votes
0answers
158 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 ...
0
votes
1answer
169 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....
0
votes
1answer
160 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
1answer
472 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
1answer
21 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
3answers
416 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 ...
0
votes
1answer
133 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 ...
0
votes
0answers
249 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
vote
2answers
121 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 ...
1
vote
1answer
768 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 ...
0
votes
1answer
218 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, ...
0
votes
1answer
92 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 ...
1
vote
1answer
293 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 ...
0
votes
1answer
592 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
1answer
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 ...
1
vote
0answers
56 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
2answers
5k 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 "...
1
vote
0answers
66 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 ...
1
vote
1answer
41 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:...
0
votes
2answers
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 ...
1
vote
1answer
330 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 ...
1
vote
1answer
12k 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 ...
1
vote
2answers
456 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, ...
0
votes
1answer
72 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
1answer
676 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 | | | ...
0
votes
1answer
137 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 ...
0
votes
1answer
86 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 ...
0
votes
0answers
67 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 ...
1
vote
1answer
853 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 ...
0
votes
0answers
190 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
1answer
25 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 ...
0
votes
2answers
584 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 ...
0
votes
1answer
74 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 ...
0
votes
1answer
676 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. (...
-2
votes
1answer
66 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
1answer
133 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 ...
1
vote
1answer
84 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
0answers
318 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
1answer
117 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 ...
1
vote
0answers
628 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 ...
0
votes
1answer
45 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 ...
0
votes
0answers
53 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 ...
1
vote
2answers
35k 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 ...