216,501 questions
0
votes
1
answer
23
views
How to add an “Other” option to a List Box in Access Forms that allows typing a custom entry using VBA Body
I’m creating a form in Microsoft Access with a List Box for users to select their usual food preferences. The list box options are:
Meat-based (beef, chicken, pork, fish, seafood)
Plant-based (...
- 1
2
votes
1
answer
115
views
Is it possible for us to go without VBA or other programming language, and how can we do this (shown) by using excel formula only?
We want to record the date of certain events by using MS excel. For example, we have borrowed 5 books from a library. Whenever we renew each of them, we should log down the date, which we perform the ...
- 31
0
votes
0
answers
51
views
Average Calculation in Visual Basic [closed]
So, I want to code the average grade of a certain number of tests, but the number of tests can vary. I looked at how to calculate the average grade by just adding every text box together, but since ...
0
votes
0
answers
63
views
Downloading Barchart.com table using Excel VBA
I'm trying to download the barchart data table from https://www.barchart.com/investing-ideas/ai-stocks
using Excel VBA in similar manner as the python script in Automatic file downloading on Barchart....
- 1
0
votes
1
answer
59
views
VBA Selection.InsertCaption and automatically adding non-breaking space between the label and number
Recently I had the pleasure to review a few specification documents edited in MS Word, containing around 1000 tables and figures, each of those with a caption that did not separate caption label and ...
-2
votes
2
answers
123
views
Copy all rows with common value in a column to new file [closed]
I need to copy all the data into a new sheet or new file based on the specified city in the dataset as shown in the below image.
Ex.
Los Angeles has 4 rows of data,
Chicago has 2 rows of data,
Miami ...
- 77
0
votes
0
answers
60
views
VBA Loop Through Sub Folders and Copy Files - "Object Required" Error [closed]
I'm getting an error when running this. Any help would be appreciated. "Run-time error '424': Object Required". Shows the error on the GetExtensionName lines.
Sub ...
- 11
1
vote
1
answer
131
views
Format() Entire Strings (Rather Than Characters)
Background
VBA has a Format() function which converts any value to its textual representation. This is useful for numbers and Dates and times, but it can also be used on Strings.
Debug.Print Format(&...
- 3,358
2
votes
3
answers
73
views
Macro overwriting incorrect workbook
I created a macro to copy and paste two tabs into a new workbook, and subsequently copy the data and paste it as values to be prepared for a submission. However, when I go to use this macro, it ...
- 21
1
vote
1
answer
90
views
Export sheet changing empty string ("") with BLANK()
I need some support to modify the vba code below. The code is designed to export data from the sheet "Export" to a new workbook that should then be loaded in an external online tool.
The ...
- 11
1
vote
0
answers
99
views
Can VBA code be executed in another user's open instance of a shared Excel workbook by taking action in my open instance of the same Excel workbook? [migrated]
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 ...
- 49
1
vote
0
answers
98
views
How to wait for “Shell” command to end before executing further VBA code?
In my Excel VBA macro, with a “Shell” command I call a PowerShell (which executes a Python script), and temporarily during the development I print out the return code:
x = Shell("POWERSHELL.exe -...
- 11
-3
votes
1
answer
77
views
Excel multiple users simulaneously edit + data restriction [closed]
I have an excel file (.xlsb) on sharepoint (Teams).
Permissions are granted to "edit mode" for over 150 users.
Multiple users editing at one time is not a problem, but I wanted to add ...
- 3
2
votes
3
answers
146
views
Showing VBA macro output in a VBS script
I'm running a VBA macro through a VBS Script:
scriptDir = CreateObject("Scripting.FileSystemObject").GetParentFolderName(WScript.ScriptFullName)
Set excel = CreateObject("Excel....
- 2,074
1
vote
2
answers
99
views
VBA Autofilter does not return correct number of rows
When I filter any column down to two rows being visible, I run the Sub SaveAllFilters().
I then manually remove the filters to show all columns/rows. Then when I try to apply the Sub ...
- 91