Excel-VBA (Visual Basic for Applications for Microsoft Excel) is the dominant programming language for Microsoft Office Excel. It is an event-driven and object-oriented programming language for writing macros for Microsoft Office applications like Excel. DO NOT USE THIS TAG for VB.NET questions.

0
votes
0answers
6 views

active-x radio button blocking access to excel cells

I have active-x radio buttons which when they are clicked are preventing to access any excel cell. Cells are all accessible until one radio button is activated. The worksheet is unprotected.Main ...
0
votes
1answer
15 views

Split data in Chr(10) into new line

I want to break selection (B3, B4..etc) into new row.. Please help me. for a example=If I select B3 cell, I wanna add more 3 Rows and 2nd to 4th line should be move down. Always not same line break ...
0
votes
1answer
15 views

Statistics of Variable Range Using Criteria

I need help to calculate min, max, average using data criteria. The image below shows two columns of data namely time and speed. I want to calculate the average speed for the range from time 0 (cell 2)...
0
votes
0answers
7 views

VBA created Outlook Appointment not responding after adding attachments

I scraped together/built a Sub in VBA to create Outlook appointments based on some of the variables predetermined on 2 of my excel sheets (Subject, Start Time, Content etc....)The code runs fine at ...
0
votes
0answers
11 views

VBA Dynamically Filter Multi-Column Table Using Column of Product Numbers

I am trying to figure out how to filter a data table of products as I type a product # into an Active X Control listbox. I named the data table (found in the Design tab which is visible upon having ...
0
votes
0answers
20 views

Compile Error: Duplicate Declaration

I have this code here:Dim c As Long, rG As Range, vR As Variantc=wsC.Range("A" & Rows.Count).End(xlUp).Row + 1Dim wsA As Worksheet, wsC As WorksheetSet wsA=Sheets("Active")Set wsC=...
0
votes
3answers
17 views

Use cell value to activate another sheet then clear original cell value without an error

I have cell A1 on a sheet named "Data" that looks for input which when received, looks for a sheet name that matches it. If it finds a match, it opens that sheet. I'm trying to clear the value entered ...
-1
votes
0answers
37 views

Copy data from invoice to separate worksheet

I am looking for VBA code that will copy invoice data to a separate worksheet with a button (e.g. "Save Invoice"). I tried some VBA solutions, but I can't seem to find a feasible solution. (Below are ...
-1
votes
0answers
16 views

get sum for each date from multiple sheets into one ( Main or Master) sheet by vba code

I have more than 30 worksheets with same format, I have total sum for each date in worksheet. But now I want to get total sum for each date from every sheet into one sheet( Main or Master) as i ...
-1
votes
1answer
21 views

Excel Data management / Macro creation

I'm looking to automate a process and collate the information.Column A - Timestamps Column B - Current MeterColumn C - Shadow MeterI want excel to select Column A - take all of the ...
0
votes
0answers
24 views

Runtime error #91, Object variable or with block variable not set

I have added search command button to userform in excel VBA and wanted to search the data through the dates displayed in combobox. The idea is to search date in worksheet called ICC_Data and if it ...
1
vote
1answer
36 views

How can I “UPDATE a DATE based on a CELL CHANGE in Excel?”

Firstly, I tried scouring through the posts (as I've come to this site a lot) for my answer, but I can't seem to find what I'm looking for.This is a little background and "why," if you will; in Army ...
0
votes
0answers
32 views

Compare cells of common rows in different files

What I have until now:The code below scans 2 sheets and checks if the same cells have identical values.If not , highlights the cell that has the discrepancy of the first sheet.What I need extra:...
-3
votes
1answer
18 views

Transpose n column in excel with macro VBA

Greeting I am new to VBA and excel . I need to transpose N column from a sheet to another sheet with a macro .PS I need a macro not using the predefine copy and paste transpose in excel and thanks ...
0
votes
0answers
14 views

vba - Populate treeview child nodes checked/unchecked according to range data

I have a userform with a treeview control containing parent and child nodes with checkboxes.Parent and child nodes are populated according to range data.This is the code I use to populate treeview ...

153050per page
angop.ao, elkhabar.com, noa.al, afghanpaper.com, bbc.com, time.com, cdc.gov, nih.gov, xnxx.com, github.com,