Stack Overflow
Stack Overflow

Questions tagged [vba6]

Visual Basic for Applications (VBA) is an event-driven, object-oriented programming language for writing macros, used for the MS Office suite as well as other applications. VBA is not equivalent to VBA6, VBA7, VB.NET, or VBS. If your question is specifically about programming any MS Office application, also use the appropriate tag: [excel], [ms-access], [ms-word], [outlook], [powerpoint] or [ms-project].

Visual Basic for Applications (VBA) is an event-driven programming language which was first introduced by Microsoft in 1993 to give Excel 5.0 a more robust object-oriented language for writing macros and automating the use of Excel. The language and its runtime quickly matured and began being used in products beyond Microsoft Office applications.

Differences between VBA 6.0 and VBA 7.0?

There's not a whole lot that has changed between VBA6 and VBA7. VBA7 was introduced to support 64-bit versions of both Office and Windows while VBA6 only supports the 32-bit versions of Office.

Reference

Differences between VBA 6.0 and VBA 7.0

139 questions
1
vote
2 answers

How to modify the appearance of UserForm Labels using Class Module?

I have this UserForm (Image 1) and I'm trying to apply some customization through Class Module. So, my first goal was to modify the label format when it was clicked (Image 2). So far so good, I've accomplished this through the Class Module…
Ninja
  • 15
  • 1
  • 6
1
vote
0 answers

How to get Office Development Tools in VS Community on Windows 10 64bit?

2 Closely related questions, an explanation that may help find a partial solution for other sufferers if this problem is widespread, and an opportunity for someone to make this better: Is there a better functionality in Office Developer Tools…
Neil Dunlop
  • 387
  • 3
  • 16
0
votes
1 answer

Passing Power Query M through VBA

I need to pass the following Power Query M through my VBA Script: let Source = Excel.CurrentWorkbook(){[Name="C192767TO15_D3"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"Item", type any}, {"Process Date", type datetime},…
Phentius Khan
  • 5
  • 3
0
votes
0 answers

Case and IF statement errors

I have been working on a piece of code and have ran into some errors with some if statements. I keep getting the error "block if without end if" I have changed my code around and done some research but have not been able to figure it out, me moving…
hakai
  • 1
0
votes
0 answers

Excel VBA With Pivot Table From Data Model

I make a query with connections in data model then i make some measures and make some pivot table to excel sheet with filter field. now i want to connect my pivot tables with VBA to clear or select all filter in all PVT fields based on a dropdown…
Mohamed Adel
  • 1
0
votes
1 answer

Have a newly created template sheet with table automatically append mater table. Building a fully automated template, hung up on the PowerQuery

The Project Premise: Creating a invoice tracking template that automatically appends a table on the newly created invoice worksheet to an existing table on the Master Worksheet. The process will work as follows: Existing: Invoice Template, Master…
Phentius Khan
  • 5
  • 3
0
votes
1 answer

Locking the Textbox Position To Be the Same While Update

I am creating a calendar feature in Excel that takes inputs from a form and based on that I will put the job details into the dynamic calendar. The problem I'm facing now is that whenever I'm updating a textbox position, it will re-position to…
Kingly Lee
  • 1
  • 1
0
votes
0 answers

Ensure Textbox remain at same position when I update the form

I am creating an calendar features which takes inputs from a form and based of that I will assign into a dynamic calendar. The problem I'm facing now is that when I update my form the first textbox position does not remain at its original position…
Kingly Lee
  • 1
  • 1
0
votes
1 answer

Putting a textbox directly below another textbox in the same cell in Excel VBA

I am creating a calendar feature which takes inputs from a form and based off that I will assign into a dynamic calendar. The problem is that my third textbox and subsequent textbox will not be directly below the previous textbox created. . It is…
Kingly Lee
  • 1
  • 1
0
votes
0 answers

User-defined type not defined for mscoree.CorRuntimeHost

I am trying to automate edge without installing selenium using VBA but I am getting error while using the selenium wrapper code, did I miss anything on this code or do I need to add any settings in my Excel addin? My code below: Function…
komal gade
  • 1
  • 1
0
votes
1 answer

Implementing User-Defined Function (UDF) with IF equations

I'm working on a function that uses different formulas based on the DOH of a specific Person in different groups. Some groups may use different formulas depending on the status (if it's active or non-active). I need the results to be outputted in…
alxn
  • 1
  • 2
0
votes
1 answer

Output formula results based on a word in a specific column and row

I'm building a function that uses different formulas based on the DOH of a specific Person in different groups. Some groups may use different formulas depending on the status (if it's active or non-active). I need the results to be outputted in the…
alxn
  • 1
  • 2
0
votes
1 answer

How do I Unzip a 7z zip file using VBA

I have a 7z .zip file I am trying to unzip with VBA. I have attempted several methods but to no avail. See below the zip file type just to be sure where the problem could be from: Image of 7z file I try the below code, it runs, downloads every…
bhukz
  • 3
  • 2
0
votes
1 answer

Doesn't show the value on the sheet

The code have to do this: Open the external file to push the information, if the id is the same at the other sheet they copy the value of the two columns and paste on the column on the sheet "Controle Geral", if he is not empty jump 2 columns and…
Ramon Bernardo
  • 1
0
votes
1 answer

The code is not extracting the complete specification part

I tried to extract the specification part for a few URLs, "Example Link - https://in.rsdelivers.com/product/3m/3400961/fall-arrest-fall-recovery-kit-3m-3400961/1965607", However, using the code below, I was only able to extract half of the specs;…
jaga jagga
  • 37
  • 3
1 2
3
…
9 10