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
0
votes
0 answers

return value based on 3 criteria

I know this can be accomplished with a vlookup or index match, but I need this to work in VBA. Is this possible? I tried using the application function but can't get it to work with more than 1 criterion. Let's say we have a Price Table in worksheet…
Belle
  • 1
0
votes
2 answers

Obtain a list of information Pertaining to a Specific Month

I have trouble running this script to obtain Summary information for a specific month. I am explaining below the details of my workbook. Tab 1 called "Schedule" Tab 2 called "Results" Tab 3 called "Sheet3" I would like to obtain info from column C…
MiaLea
  • 1
  • 2
0
votes
0 answers

How to overcome "compile error expected: sub or function" in vba Add ins MS office 2007

I have been creating an excel add-in that even works with ms office 2007, 2010, and 2013,... including custom UI below is my module code Declare PtrSafe Function GetKeyState Lib "user32" (ByVal nVirtKey As Long) As Integer Const VK_CONTROL As…
Nixs
  • 29
  • 7
0
votes
0 answers

Reference Initialized Dictionary In Other Modules | Excel VBA

I am somewhat new to the VBA arena (currently deal more with Python & Bash), but am attempting to utilize an initialized dictionary for applications across other modules. Consider the following dictionary construction contained inside a Sub,…
TornadoEric
  • 399
  • 3
  • 16
0
votes
0 answers

Advance Filtering with Dynamic Criteria Range (Changes based on Filter) in VBA

I have been trying to implement Advance Filtering using VBA with dynamic Criteria. The Criteria Range will change based on the Filters on a Table from where I am picking the Criteria (located on a different sheet). For example, in the below picture…
Salonee Sonawane
  • 41
  • 6
0
votes
1 answer

Are there VBA classes that generate JWT for DocuSign OAuth2?

We are using MicroSoft Access 2016 32-bit VBA to call DocuSIgn API for generating and sending envelopes, and reading DocuSign data. We are trying to convert from DocuSign's legacy authentication to OAuth2. We do not have the option at this time to…
PSD
  • 63
  • 8
0
votes
1 answer

Add the sum of the total amount from the sheet

Thanks for opening my thread. I need help from you. So in this sheet the total amount should be sum of fuel + surge + delivery_charge should be added in Total amount column. Ex:- 1st order = 456777 this should add 109.49+303.41+25966.51 =…
Ranger
  • 5
  • 2
0
votes
2 answers

Remove all formatting when copy and pasting with Word

In word there is the ability to Edit > Paste Special > Unformatted Text, and I'd like to do this by default. I've created a Macro that reads: Selection.Collapse Direction:=wdCollapseStart Selection.PasteSpecial DataType:=wdPasteText Which seems…
Hemphta
  • 1
0
votes
0 answers

How to conditional copy unique values only?

I want to copy unique values over to my destination worksheet but I'm getting an error with my Range. Originally I wrote a RemoveDuplicates code with exact same Range values and it worked perfectly fine. I'm assuming the issue is in my…
vliwei4
  • 1
  • 1
0
votes
0 answers

VBA - IFELSE and Continuous Looping

I want to have 2 formulas with continuous looping as long as there is value in the cell next to the targeted cell, thus i need to have ifelse function but with continuous looping aswell. for now i don't know how to insert the second…
Fernando
  • 1
0
votes
1 answer

Iterate through two columns and follow hyperlink

I have a workbook: Col. C & Col. AG have hyperlinks to other sheets in the same workbook. I want to iterate through col. C to open the hyperlink, copy the sheet Then return to the main sheet to Iterate through col. AG to open the hyperlink, and…
Mennatallah Adam
  • 3
  • 1
0
votes
3 answers

Runtime Err 438 for Outlook.Application.Recipients.Add()

ISSUE: Outlook Automation fails at [Outlook Application].Recipients.Add ("Jon Grande") Error message: Runtime Error 438: "Object does not support this property or method. MS example:…
Graham Smithwick
  • 1
  • 1
0
votes
0 answers

Prompting/Displaying a Filter box for a specific column

I need a code which selects the column and displays the Filter box as shown in the below image("This is a filter dropdown which allows us to select the list of values"). I want a code which follows the following steps Select column A Prompts us the…
Manoj Gaidhankar
  • 1
  • 1
0
votes
0 answers

No cells found - excel

I get a error that no cells are found and it highlights Range("A6:A109").SpecialCells(xlCellTypeVisible).Find("Temp").Select When I open the file it looks like this below and column F is hidden and that's where my value is. How and where can I add…
Kim
  • 31
  • 5
0
votes
1 answer

Created Custom Formula is showing @ why?

Formula is showing @ symbol. why it is showing. and how can i solve it.
Srinivas Ch
  • 1,202
  • 2
  • 19
  • 34
1 2 3
…
9 10