Developer technologies Visual Basic for Applications

0 answers

Why not remaking a certified exams for vb.net language?

Just because it's one of the easier languages to learn, I think Microsoft should bring back the vb.net certification exams.

asked

Hugo Maelasi Oto 0

2 answers

DLL file not found when invoking function from Excel/VBA

I'm running Windows 11 with 64-bit MS/Office 2021. I have a very large (>25KSLOC) Excel/VBA application with a helper DLL written in C and compiled by Visual Studio 2022. The last time I used the app was May 4, 2025, and it worked perfectly. Today,…

asked

Chris Grossman 25

commented

Chris Grossman 25

1 answer

Power Query memory increasing when data connections refreshed simultaneously (manually or via VBA)

Hello all, I've been coming across an issue using Power Query in Excel 365 (Enterprise E3, both 32 and 64 bit version). I have 4 Power Query data connections using an API query to retrieve JSON data automatically every 10 seconds, transform into…

asked

siers 21

commented

Adeline 0

1 answer

Debugging VBA

I am a beginner in VBA programming, I am writing a function to retrieve the cell value from another file. However, I made a lot of attempts but still cannot get it work. May I know where can I get assistance?

asked

Victor Leung 20

commented

Victor Leung 20

3 answers

VBA macro to file sent mails

I am using since many years a macro which executes when I send a mail and asks me, in which folder I want to store this sent mail (instead of leaving it in the "sent mail folder"). This macro is: Private Sub Application_ItemSend(ByVal Item As…

asked

Gaston_63 40

edited the question

simo-k 57,980 Volunteer Moderator

0 answers

Subject: Request for Custom SharePoint Domain Name Change or Guidance

Description: Hello Team, We are currently using Microsoft 365 services with SharePoint Online, and our tenant domain is provisioned as: https://netorgft12893109.sharepoint.com However, for branding, end-user experience, and professionalism, we would like…

asked

Anil Mondeti 0

2 answers

Row Height changes after filtering

Environment: Excel Office 365 running in client on Windows 10 The worksheet has all columns set to Wrap Text so column width is retained. Problem Description: I show all and auto fit rows - everything looks fine. Then I filter, and the rows no longer…

asked

Jennifer Thomas 1

answered

Michelle Trudeau 0

1 answer

Excel VBA, StrPtr

Hi all. I guess it's been a while since I've been here.... everything has seriously changed. A long time ago, an Excel MVP had helped me with the 2007 changes to the Ribbon, and working with his code, I'd created a gallery for my Excel Ribbon. It…

asked

Steve B 1

answered

HARDCORE GAMES™ 165

0 answers

Fail to run a Excel VBA Code in Windows Server while successfully run it in Windows 11

I have an Excel file with a bunch of VBA code from my teammate. I tried to open and run the VBA function in Windows 11, and everything worked successfully. However, when I tried to open this Excel file on a Windows Server, I encountered a runtime…

asked

Ernest Chan 0

edited the question

Ernest Chan 0

1 answer

cant log into my account

i ca not log into my email this keeps coming up Please retry with a different device, use a VPN, or other authentication method to sign in. For more details, please see https://go.microsoft.com/fwlink/?linkid=2317517

asked

Pat Clifford 0

commented

Fabio Del Río 0

2 answers

How to use SUM or other functions to sum the cells of the established IF function in Excel?

The cell formula of the established IF function is =IF(O2+P2+Q2<=80,"80",IF(O2+P2+Q2<=110,"150",IF(O2+P2+Q2<=140 ,"190",IF(O2+P2+Q2<=140,"190","230")))) I want to add up these result values,…

asked

尉寧羅 21

answered

Ashish Mathur 99,580 Volunteer Moderator

1 answer

Batch Send Emails in Outbox

As part of my work, we occasionally send large batches out emails to contacts we work with. We use a script to attach files to them and Work Offline, so we can review them after they're set in our mailbox. We recently started using a second mailbox for…

asked

Liam_CO 1

commented

Mark Shaw 0

5 answers

Training Log in Excel

Hey there, I'm trying to set up a training log in excel, basically it will be a list of users, and the training they've taken. There will be a scrollable list of users, when you click a user I want excel to display which training they've taken. …

asked

Ray Flits 11

answered

ScottGem 68,755 Volunteer Moderator

2 answers

How to determine the frequency of an exact array's values?

I am having some issues with finding out the frequency of an exact array's values Examples: Result: [3, 6, 8, 9, 10] [3,4, 6, 8, 9] [3, 6, 8, 9, 10] Results: Count of exact array's values [3, 6, 8, 9. 10] = 2 [3, 4,…

asked

JohnCTX 636

answered

Ashish Mathur 99,580 Volunteer Moderator

1 answer

Modification to VBA Code - Copying data after drop down list value change and pasting to another sheet

Hi. I have this code which I need some assistance modifying - see below. First modification is the DropDownCell range should include all of column A that contains data not just cell A1. So if you change the value of any cell in column A using the…

asked

Alverna 0

commented

Alverna 0

0 answers

How to fix my high jump app I’m missing all kinds of doors and I can’t add trip numbers to doors I don’t have access too

I don’t have access to my doors is transfers I’m missing 322 323 502 503 505 506 and 507

asked

Large, Troy 0

0 answers

VBA: userform location on the screen is incorrect in Word365

Simple test to showcase the problem (in Word VBA): Create a userform. In UserForm_Activate write Call Me.Move(0, 0, Application.UsableWidth, Application.UsableHeight) This is supposed to cover the entire application screen, right? And in Word2013 is…

asked

Eugene Z 20

0 answers

im unable to adjust my brightness, it turned grey and i had to change my display setting to 'show 1' everytime i open my pc

im unable to change my brightness level, i had to change my display setting everytime i open my pc to 'show 1' display i dont know what to do, my brightness level turned grey

asked

vishav bhardwaj 0

0 answers

MICROSOFT DOWNLOADER

USEDERROR The extension 'name' already exists in the Marketplace.

asked

ABHI JITH 0

0 answers

I want to learn free course of UX/UI design, unable to get the link

I saw a video suggesting to learn ux/ui from Microsoft learn, it is 4 4-hour courses. I am unable to locate it

asked

AMOL KUMAR 0

Developer technologies | Visual Basic for Applications

Filter

Content

1,520 questions with Developer technologies | Visual Basic for Applications tags

Why not remaking a certified exams for vb.net language?

DLL file not found when invoking function from Excel/VBA

Power Query memory increasing when data connections refreshed simultaneously (manually or via VBA)

Debugging VBA

VBA macro to file sent mails

Subject: Request for Custom SharePoint Domain Name Change or Guidance

Row Height changes after filtering

Excel VBA, StrPtr

Fail to run a Excel VBA Code in Windows Server while successfully run it in Windows 11

cant log into my account

How to use SUM or other functions to sum the cells of the established IF function in Excel?

Batch Send Emails in Outbox

Training Log in Excel

How to determine the frequency of an exact array's values?

Modification to VBA Code - Copying data after drop down list value change and pasting to another sheet

How to fix my high jump app I’m missing all kinds of doors and I can’t add trip numbers to doors I don’t have access too

VBA: userform location on the screen is incorrect in Word365

im unable to adjust my brightness, it turned grey and i had to change my display setting to 'show 1' everytime i open my pc

MICROSOFT DOWNLOADER

I want to learn free course of UX/UI design, unable to get the link