VBA

5K

Solutions

18

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.

Refine results

Hi, Please Please help, I'm stuck and frustrated by what must be a simple thing to overcome! I thought Mr Google has the answer to everything, but today he's falling short!

I'm nearly finished …

139 views
DevOps Toolchain Recommendations
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Hello everyone,
I need to add a rectangle inside a chart and actually make it a part of this chart.
I'm doing this because I need to display this rectangle in an image box, and the only way to do so…

919 views

Hi Experts.

I have an Access Application that was created and compiled in Access 2010.  It installs and runs correctly on a Windows 7 64 Bit PC with Access 2010 Runtime.

When I install it on a …

2131 views

hi EE,

1. What is the best way to re-number column No (A) from 1 to visible rows please
2. e.g if I apply filter on Group1 with Yes rows. As it is now. in the sample file attached.
3. How to make…

619 views

I set up am excel macro to pull in a spreadsheet of line item PO's and then it formats for our shipping system.   Im able to pull in the worksheet, name ranges etc.   The problem Im having is naming …

222 views

I have thousands of rows with groups of urls in one cell on each line.  I need to write some vba to extract each url, (multiples in each cell) that start with the tag hiRes:https.   I need to extract …

411 views

Hi EE,
could you help with attached sample excel and how to achieve this please?

Basically
1. How to get Final Column (G) the Consolidated result using formula please?
2. If any one of the group…

58 views

Hi Experts,

    Curious if someone has a macro that will capture and notate ALL changes made to a workbook and then email out out those changes made to an email address or distribution list?  For …

315 views

I found the below code and it works, but it adds extra space to the column height.  How can I remove the extra space?

(CODE)

1212 views

I am attempting unsuccessfully to format data in Excel as a table from Access.  I was hoping someone could tell me what I'm doing wrong:

First way:
(CODE)

Second way:
(CODE)


Third way:

1112 views
PRTG Network Monitor: Intuitive Network Monitoring
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

I wonder if thats even possible. Is there a way to store via VBA a value in a Label control, and that value sticks, even after closing and open ms access without aid of a table?

1916 views

Hi All

I have data in a spreadsheet that is exported from a guest Wi-Fi system.  Users are required to enter a name and email address, or use a social media account to use the free Wi-Fi.  That …

617 views

Hello Fellows

Im about to implement a control on a form with the characteristic of a listbox that show to the user what record as been "updated", for this i need a listbox with row color, but for …

316 views

I'm struggling to hide a range of columns in another worksheet.  The closest I've got is this code but that only hides them on the sheet I'm on:

Private Sub Test2()
Dim sws As Worksheet, dws As …

2524 views

Hi,
I cannot unhide columns, D, E, F, to the attached file. Why?

516 views

Hello Fellows

Im trying to insert a new line in a memo richtext control, but the vbNewLine and vbCrLf dont work there. Is there a way  to do this?

Thanks in advance for your suggestions

817 views

Hi, I need help by coding a simple macro as a neophyte. I have to create different lists from the data.

My workbook has 3 sheets.

Sheet 1 =  I have to paste here the copied columns from sheet …

423 views

I have a csv file that only has data in column A. I have an excel workbook that I copy column A from the CSV to this excel workbook that I use to populate a mailing list. Problem is right now I am …

814 views

I am using the code
(CODE)

It removes some lines, but not all dups.
For instance GR 3 12x9x6 has (2) rows. Based on the code, there should only be (1) row.
It should remove anything that is the …

3515 views
Windows Server 2016: All you need to know
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

When I run my code, I'm getting the following errors:

 Error: 1004
 ExportToExcel
 Application-defined or object-defined error

 Then if I click on OK, it continues through the code, but  then …

1017 views

Hi guys what am i doing wrong? I get an error when trying to open the saved file again

this is the error i get:


this is the code:

(CODE)

1110 views

I have a subform that displays a list of orders  and/or quotes based on the parent form criteria selected. Many criteria on the parent form can be selected to query specific records. the SQL is …

636 views

I had this question after viewing Printing to File then Sending File to an IP (https://www.experts-exchange.com/questions/28898167/Printing-to-File-then-Sending-File-to-an-IP.html).  Towards the end …

1117 views

Hi,

I have some cells in a excel file , one of them contain xml string.
i have imported th file into access table .
the cell contains xml string imported into text field.
now, what i want is to…

2126 views

Hi folks. I have 9000 + lines of parsing in an excel format with two worksheets.

In need it to looks at the first worksheet analyze what's in worksheet 2 and tell me the differences.

Basically if …

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

TOP EXPERTS

view all

TOP VIDEOS

view all

RELATED TOPICS view all topics

  1. Microsoft Excel
    (129,496)
  2. Microsoft Access
    (216,192)
  3. Visual Basic Classic
    (163,624)
  4. VB Script
    (36,403)
  5. Microsoft Office
    (57,279)
  6. Microsoft Word
    (27,067)
  7. Outlook
    (94,936)
  8. Microsoft Applications
    (43,172)
  9. Programming
    (52,042)
  10. Spreadsheets
    (6,015)