Recent questions tagged vba

0 votes
1 answer

Runtime Error while dynamically adding controls to a userform

Mar 27, 2023 in Others by Kithuzzz
 • 38,000 points • 2,084 views
0 votes
1 answer

See cell content instead of formula in formulabox in Excel using VBA

Mar 27, 2023 in Others by Kithuzzz
 • 38,000 points • 1,587 views
0 votes
1 answer

Highlight duplicates with only 2 colors

Mar 27, 2023 in Others by Kithuzzz
 • 38,000 points • 1,594 views
0 votes
1 answer

How can I set a number for a public variable at userforms in excel?

Mar 26, 2023 in Others by narikkadan
 • 86,360 points • 1,774 views
0 votes
1 answer

Loop through each cell in a given range and change the value depending on value in a column in the same row

Mar 26, 2023 in Others by narikkadan
 • 86,360 points • 2,209 views
0 votes
1 answer

ActiveSheet.Hyperlinks.Add don't show Text To Display

Mar 26, 2023 in Others by narikkadan
 • 86,360 points • 1,799 views
0 votes
1 answer

Combine Two Formulas in Separate Cells Into One Cell

Mar 26, 2023 in Others by narikkadan
 • 86,360 points • 2,361 views
0 votes
0 answers

Excel Formulas Limitations when compared to Excel VBA Power

Mar 26, 2023 in Others by narikkadan
 • 86,360 points • 1,220 views
0 votes
1 answer

Extracting a Variable Number of Letters from a Formula using VBA Code

Mar 26, 2023 in Others by narikkadan
 • 86,360 points • 1,743 views
0 votes
1 answer

Select data that meet criteria from a table, adding it to a combobox in userform VBA Excel

Mar 26, 2023 in Others by narikkadan
 • 86,360 points • 2,778 views
0 votes
1 answer

TextEffect to TextFrame Adjustment (Mismatch)

Mar 25, 2023 in Others by Kithuzzz
 • 38,000 points • 1,906 views
0 votes
1 answer

Run time error 3343 unrecognized database format

Mar 25, 2023 in Others by Kithuzzz
 • 38,000 points • 1,689 views
0 votes
1 answer

VBA & Ascii Art

Mar 25, 2023 in Others by Kithuzzz
 • 38,000 points • 1,855 views
0 votes
1 answer

VBA Macro to add a relative reference column

Mar 25, 2023 in Others by Kithuzzz
 • 38,000 points • 1,621 views
0 votes
1 answer

VBA - Build a Two-Column Array By Looping Through one Array with a Specific Criteria and Selecting From Another Array

Mar 24, 2023 in Others by narikkadan
 • 86,360 points • 1,563 views
0 votes
1 answer

VBA Regular Expression to return ALL matching patterns

Mar 24, 2023 in Others by narikkadan
 • 86,360 points • 2,706 views
0 votes
1 answer

Macro VBA code failing to execute a section of the code without an error

Mar 24, 2023 in Others by narikkadan
 • 86,360 points • 2,315 views
0 votes
1 answer

Open Existing PowerPoint via VBA

Mar 24, 2023 in Others by narikkadan
 • 86,360 points • 2,820 views
0 votes
1 answer

VBA how to calculate depth of items in excel, simliar to a BOM system

Mar 24, 2023 in Others by narikkadan
 • 86,360 points • 2,085 views
0 votes
1 answer

Export multiple worksheets without formula with the ability to select exact sheets and location

Mar 24, 2023 in Others by narikkadan
 • 86,360 points • 1,889 views
0 votes
1 answer

Check multiple cells in excel, move to next cell if null and if value found stop and return that value

Mar 24, 2023 in Others by narikkadan
 • 86,360 points • 1,892 views
0 votes
1 answer

Open Workbook on new instance

Mar 23, 2023 in Others by Kithuzzz
 • 38,000 points • 1,714 views
0 votes
1 answer

VBA - Build an Array by Looping Through Another Array with Specific Criteria

Mar 23, 2023 in Others by Kithuzzz
 • 38,000 points • 1,848 views
0 votes
1 answer

How to programmatically get the values of a spilled Excel range in VBA?

Mar 23, 2023 in Others by Kithuzzz
 • 38,000 points • 3,914 views
0 votes
1 answer

VBA to create a dynamic rolling list of names

Mar 23, 2023 in Others by Kithuzzz
 • 38,000 points • 1,566 views
0 votes
1 answer

VBA Loop to select then copy a range of cells based on value in column B

Mar 23, 2023 in Others by Kithuzzz
 • 38,000 points • 4,331 views
0 votes
1 answer

Merging duplicate cells into a new column with VBA

Mar 23, 2023 in Others by Kithuzzz
 • 38,000 points • 1,610 views
0 votes
1 answer

Excel VBA- How to loop through specific sheets in a workbook and format the same ranges in each sheet

Mar 21, 2023 in Others by narikkadan
 • 86,360 points • 3,706 views
0 votes
1 answer

Encrypting and securing sheets for users

Mar 21, 2023 in Others by narikkadan
 • 86,360 points • 1,529 views
0 votes
1 answer

Why does this VBA Macro that copies and paste range into email in the wrong order?

Mar 21, 2023 in Others by narikkadan
 • 86,360 points • 2,246 views
0 votes
1 answer

Excel VBA Selecting Multiple columns with last row and apply Condition Format

Mar 21, 2023 in Others by narikkadan
 • 86,360 points • 2,678 views
0 votes
1 answer

Excel VBA code not running using F5 only F8

Mar 21, 2023 in Others by narikkadan
 • 86,360 points • 1,857 views
0 votes
1 answer

Issues with a VBA code for excel that takes the geolocation info (longitude, latitude, altitude) from a set of files in a folder

Mar 21, 2023 in Others by narikkadan
 • 86,360 points • 2,552 views
0 votes
1 answer

VBA Macro Iteration

Mar 20, 2023 in Others by Kithuzzz
 • 38,000 points • 1,939 views
0 votes
1 answer

Loop through files using "" instead of Dir

Mar 20, 2023 in Others by Kithuzzz
 • 38,000 points • 1,554 views
0 votes
1 answer

Delete table rows if time in column is >07:45

Mar 20, 2023 in Others by Kithuzzz
 • 38,000 points • 1,408 views
0 votes
1 answer

VBA Excel FormulaR1C1 "Application Defined or Object Defined Error"

Mar 20, 2023 in Others by Kithuzzz
 • 38,000 points • 1,633 views
0 votes
1 answer

VBA - Dynamic Variable Name in a Loop

Mar 19, 2023 in Others by narikkadan
 • 86,360 points • 3,470 views
0 votes
1 answer

Use union with find

Mar 19, 2023 in Others by narikkadan
 • 86,360 points • 1,654 views
0 votes
1 answer

VBA Excel get data from Access database Error

Mar 19, 2023 in Others by narikkadan
 • 86,360 points • 1,932 views
0 votes
1 answer

VBA - Msgbox inside a Loop

Mar 19, 2023 in Others by narikkadan
 • 86,360 points • 2,021 views
0 votes
1 answer

Runtime Error when trying to Loop Worksheets

Mar 19, 2023 in Others by narikkadan
 • 86,360 points • 1,762 views
0 votes
1 answer

Filter date with time

Mar 19, 2023 in Others by narikkadan
 • 86,360 points • 1,558 views
0 votes
1 answer

Copy data with filter applied using Excel VBA

Mar 19, 2023 in Others by narikkadan
 • 86,360 points • 1,939 views
0 votes
1 answer

How do I adjust the size of the pasted image in Outlook email?

Feb 27, 2023 in Others by Kithuzzz
 • 38,000 points • 3,043 views
0 votes
0 answers

Input Box Date Validation

Feb 27, 2023 in Others by Kithuzzz
 • 38,000 points • 1,305 views
0 votes
1 answer

VBA Comment Format

Feb 27, 2023 in Others by Kithuzzz
 • 38,000 points • 1,709 views
0 votes
1 answer

VBA: Do While Loop does not want to looping

Feb 27, 2023 in Others by Kithuzzz
 • 38,000 points • 1,995 views
0 votes
1 answer

How to read excel file column by column

Feb 27, 2023 in Others by Kithuzzz
 • 38,000 points • 1,555 views
0 votes
1 answer

Excel VBA Type Mismatch calling Private Sub from ListBox_Click

Feb 27, 2023 in Others by Kithuzzz
 • 38,000 points • 2,372 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.