#vba

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...

I have a Input Form / Table for Data Entry which is presented to a client for completion. As the Table could be 5 to 100 entries long I can not compensate for the unknown about of required rows. Each Table thus has a number of records provided, but needs to “grow” based on the data entry, to...

@how can I show a icon in Excel when I click on a Description column (Range (A15:A30) , if i will click after open Userform ? Icon Move After cell Selection. kindly Need VBA Coding

I have both sides of the code but do not know how to join them together. One part of the cod will pull the Windows user name but not work with a selected range and not work with if there is a change in that range. The other part works with with timestamping when ever there is a change within a...

If column O is exactly "Sanitary", I need to add up all the numbers in L that are on the same rows that contain partial keywords: "Base", "Riser", "Cone", "Adjustment", "Ring" in column K AND contain the same value in column B. so in the sample data below, rows 21,22,23,24,25 meets all...

I need to replace the value in column H with value from a cell in column U when criterias are met here are the criterias: If column O contains keywords "P-" and "MANHOLE" and if column F contains exactly "P1" then the value in column H in the rows that meet criterias above, gets replaced by the...