#vba

Hi Everyone, I have an annual assessment form that collects data from certain fields and based on the grading given to those fields, specific comments will be generated on column "AH" for each respective employee. All those comments state "Employee" at the beginning of each sentence. What I...

Sub ExtractTableFromEmailToExcel() On Error GoTo ErrorHandler ' Start error handling Dim OutlookApp As Object Dim OutlookNamespace As Object Dim Inbox As Object Dim Subfolder As Object Dim Item As Object Dim HTMLDoc As Object Dim Table As Object Dim Row As...

Sub ExtractTableFromEmailToExcel() On Error GoTo ErrorHandler ' Start error handling Dim OutlookApp As Object Dim OutlookNamespace As Object Dim Inbox As Object Dim Subfolder As Object Dim Item As Object Dim HTMLDoc As Object Dim Table As Object Dim Row As...

Hi there, I am currently using the VBA code below to highlight specific text in a cell. However, it doesn't allow me to highlight a phrase with spacing in between (e.g. "live tour"). May I know how can I change the VBA so that I can highlight a phrase instead? Sub...

Hi all. I'm looking some VBA code that I can assign to a button or a formula if that will work :-) I have list headers which are copied to cells C24:C36, then I'm assigning values to cells D24:36, these values represent the amount of sequential numbers I need adding. Basically, I want to...

I have installed a third party com add-in. It is a .vsto file format. The add-in has a Refresh All button. I want to execute that using VBA. Is this even possible?

I have a code which adds a new chart in ppt. Then opens up the chartdata workbook and pastes in the data from an excel file. However, the source data range does not expands according to the data pasted. Can this be done dynamically using Excel VBA? I tired resizing the Table but the vba is not...

How do I set the Object reference for FactSet? I need to check if the user has FactSet or not. If yes, refresh the workbook using FactSet.

I have a code which loop through all the slides in the active presentation and checks for the name of the shape and then breaks the linking. Now, I want to rename that shape. The problem is that the shape automatically gets converted to a picture and the PowerPoint automatically assigns a name...

Dear All, I am a beginner in VBA and I wan to know the simplest way to add conditional formatting for my Macro. please help.

I need to run a excel table that dynamically changes based on form control drop down selection. I want to run a macro that changes the dropdown and copy+paste my table else where for all values in the form control. Can someone please help ? from the pic: based on brand selection, the table...

Below is the code i use i need a check to see if column i is greater than 5, if it is then send the email if not do not send the email Sub Send_Bulk_Mails() Dim sh As Worksheet Set sh = ThisWorkbook.Sheets("sheet1") Dim i As Integer Dim OA As Object Dim msg As Object Set OA =...

I have created an xlam file which is saved on the shared drive and a dozen of people use it now. However, I'm not able to save any update I make to any of my code as it opens the file in read only mode. Is there a way I could check for the USERNAME and if it does not match then open the xlam...

C D E F G Session Code Demo Practical Lecture Seminar D01 3 3 D02 3 3 In the example table above, I would like to write a VBA code to list the Session Code + Lesson Type like this D01 Demo D01 Practical D02 Lecture D02 Seminar I was able to look for a code but it just gives...

Hello, I have this VBA code, attached below, to react to a form control of a button. Anytime the user clicks the button it will pull up their photos and they can select the photo they want to use and it will paste it in a certain cell/section. After the report is done, everything gets...

We need only Visible,"Deskboard" Sheet, When I click Deskboard After Hide All other sheet Also, I will Making Purchase Order Tracking System I was Jump Sheet Using Hyperlink Also. Pleased Need VBA Coding When I click Deskboard After Hide All other sheet Also = "Deskboard" Sheet is Trigger...

When I Click cell C8, I should see the command button shown in E8 not otherwise via vba coding. i was follow this code but not working pleased help me : Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Me.Range("C8")) Is Nothing Then...

When the item-list is selected in the range in particular cell, the Shape button should be visible on the side. How it possible to make this hyperlinkbutton in table

Could someone help me, please? I've been looking at this code for hours and I can't seem to find my error. Problem: I have a form that is requesting some user information, namely: txQtdeTransfOrigem txBonusOrigem txDesagio txNovoSaldo txNovoCPM The textboxes: txSaldoOrigem, txCPMOrigem...

Hello, I am using Get & Transform in a VBA routine to get the contents of a webpage that I want to later parse. The content is bills from our state legislature and how the legislators voted. Each Bill has its own page, so I want to build the string according to the bill number and use the...