VBA

6K

Solutions

20

Articles & Videos

2K

Contributors

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Related Topics

  1. Microsoft Excel
  2. Microsoft Access
  3. Microsoft Office
  4. Visual Basic Classic
  5. VB Script
  6. Microsoft Word
  7. Outlook
  8. Microsoft Applications
  9. Programming
  10. Spreadsheets
Refine results

Hi,

i need to remove all the custom formatting of all unused cells of the workbook, as it does not have much data but file size is more than 10 MB.

can anyone please help with the VBA to do …

313 views
Free Tool: ZipGrep
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Hi,
I also want to capture values of M/C/O, on either Column 3 or 4 of Sheet5. How to adjust Scan_list4, of the attached file?

513 views

Good Day!Please help me on this..

1. I want to copy the data from these columns ID Code,Name,Store,Product Code, Brand,Form,Days,Category and Sales Using VBA.
 
2. Paste these values to another …

1823 views

Is there VBA code that will convert a mapped file path to a UNC?

Example:

P:\folder 1\myFile.xlsx  

....converts to....

\\server1\group\Public\folder 1\myFile.xlsx

415 views

in my folder C:\Flora\Downloads  i have pdf files with website link with it.

i need help with powershell so that when i run it, it removes are URLs and replaces the addtional dots / with spaces.

1625 views

Hello,

Can I reference a table by the ID and use column 2

BgRg1 = [tblVGBadgeNumRange].[ID](1).[column](2)
BgRg2 = [tblVGBadgeNumRange].[ID](2).[column](2)

314 views

i have a boss, which is a old lady and does not understand excel table structured references, every time i sent her the file, she asks me to convert the formula reference back to explicit cell …

310 views

I had this question after viewing VBA how to delete all objects regardless of its type from all worksheets in workbook …

212 views

I had this question after viewing VBA to clear/put no-fill the cells background color for all sheets of active workbook …

515 views

i have received a mess, so many entire rows and entire columns background colored and text colored.

i need help with VBA that restores all of the cells background colors and font to the default. by…

525 views
Free Tool: Port Scanner
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I am trying to figure out how to format a text Content Control for the following alpha-numeric set.
1212-121-ABC-1212
The user should simply type all characters and the formatting or mask would …

1329 views

I would like to have Unique Customer List in Userform from Sheet (Sales) Col A

319 views

Within VBA I am trying to determine how to:

Sum Column A record Count in Worksheet A  * 2 + Sum Column A record Count in Worksheet B
Compare with the Sum from  Column A record Count in Worksheet C…

729 views

Good Day! I have these code below which it gives me an error of "We can't paste because copy area and paste area arent the same size".. Please help what is wrong with these code... :(

(CODE)

339 views

Hi all, anyone can help me to solve my problem. I want save my Power Point 2010 from Excel VBA? Here I attach my Workbook. I already write code for save the PowerPoint but it does not work as what I …

525 views

Hi Experts,

I've got a fairly simple recorded macro that attempts to clean up a phone number list by removing "(", ")", "-" and spaces but while it is removing the "-" and spaces, it is not …

725 views

Hi Experts,

So, I want to use VBA to color the cell in Column C of Sheet1 if 1st three numbers * (Area Code portion of the phone #) match any of the numbers in  Column A (Area Code) on Sheet2. I'd …

2241 views

I was wondering if anyone could please help me with creating a userform through my pre-established workbook to allow me to add data to any worksheet of my choosing through one User Form.

Thanks for…

418 views

I have the below code which deletes a record if the cell has no value.  This should be a rare event (a delete).  However, for some reason when I run (click on a form button that runs the code) the …

3020 views
[Webinar] Code, Load, and Grow
[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

My OS is win 10 pro 64 bit.  I have Office 365 Business Essentials, and I use Access 2016.  I have a application where I have a Form for data entry.  
When the Form is opened, there is a command …

427 views

Dear Experts

In Access I to need to convert all the CSV files in a folder (and its sub folders) into xls or xlsx format and save then in a different place so they can be imported into the database…

1041 views

i have 3k rows in column A with lists like this

Reliance Medical,Olympus,Physiq,Boston Scientific Angiojet Ultra,Fenwal ,Ivwatch,St,. Jude Medical ,Somna Therapeutics Xoran …

1425 views

Hi,

i have a data in M column of dates for example 5.19.2017 and i am replacing the . with / with a macro.
so when i run the macro the format is changing i don't know why.

Please suggest.

819 views

Hi every one, I Hope someone can help with conditionally trimming using VBA
I have a long text string will vary from time to time but only one word "Holliday" is always existed somewhere in the text …

824 views

Hi,

I am running a macro, after running the macro the date format is getting changed and its effecting the other sheet. i have attached a sample file to the question. after running the macro the …

315 views
Show more content
201506-LO-Top-001

VBA

6K

Solutions

20

Articles & Videos

2K

Contributors

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Related Topics

  1. Microsoft Excel
  2. Microsoft Access
  3. Microsoft Office
  4. Visual Basic Classic
  5. VB Script
  6. Microsoft Word