Articles & Videos
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.
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 …
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…
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 …
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…
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 …
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 …
could you help with attached sample excel and how to achieve this please?
1. How to get Final Column (G) the Consolidated result using formula please?
2. If any one of the group…
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 …
I found the below code and it works, but it adds extra space to the column height. How can I remove the extra space?
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:
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?
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 …
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 …
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 …
I cannot unhide columns, D, E, F, to the attached file. Why?
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
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 …
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 …
I am using the 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 …
When I run my code, I'm getting the following errors:
Application-defined or object-defined error
Then if I click on OK, it continues through the code, but then …
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:
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 …
I had this question after viewing Printing to File then Sending File to an IP (https://www.experts-excha
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…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are. What are they? An Enum is just a type of variable like a string or an…
The code described here does no longer work. Please see replacement Article: http://www.experts-exchang
Walvis Bay, Erongo, Namibia
30,500 points this week
Subodh Tiwari (Neeraj)
Kanpur University, Uttar Pradesh, India
14,260 points this week
11,000 points this week
10,660 points this week
7,676 points this week