#excelvba

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

@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

how to make hyper link Button ?? when i click down in cell with show "Add New " Button (button is hyperlink) This Invoice Product name Combo box with show Hyper link button appears Out side the combo box, how to possible pleased Need this vba code , (Condition : How to fix same place in range...

hi, I'm new to Excel VBA. I am trying to write code that will select and check multiple cells. if cells contain a specific integer, then an assigned calculation would be done for the adjacent cells. I've pasted below my latest attempt to archive the above-mentioned objective Sub...

I need help with my VBA code. My code autofilters Column D(Department) from row 19 and paste to different sheets by Department Name. However, Row 1 - 18 (Headers & body text) which are currently excluded in the new sheet. I need to include row 1- 18 and paste special to keep source formatting...

# HOW TO MATCH "HSN CODE" AFTER PULL DATA ON DIFFERENT-DIFFERENT TABLES ??? We need pull data into different- different Table . Kindly Help on solve my Query, Kindly Send us Proper formula , - perfect match " HSN CODE" And pull data from TABLE1 , send to matching table

Hi everyone, I am very new to Excel VBA and am trying to figure out how to import all the data in my txt file into excel to automate the process. As of right now, it is only importing the first three lines but I am unsure how I can alter it so it imports all the data. Here is the code I...

Hi, I am looking for macro where i want to move emails from one folder to another folder in outlook where i have word file as attachments. before moving email to the another folder it should read the footer in attachment (word file) and compare it with the list i have. then it will check if the...

Dear Team, I want to calculate age based on Birthdate & Current Date in userform1, i have already created below 3 components, list of combobox1, 2 & 3 for birth date month & year respectively, __done Textbox1 for currentDate,__done & textbox2 for age calculating. ???__question Please help for...

I want to hide Columns from the last used cell in Row NO. 10 till the end column. Sub Hide_Column_Rows() Dim LastRow, LastColumn As Long LastColumn = Cells("10", Columns.Count).End(xlToLeft).Column Range(LastColumn + 2 & ":XFD1048576").EntireColumn.Hidden = True LastRow = Cells(Rows.Count...

Hi, Im fairly very new to VBA Scripting. i have a problem please find the below table Output column is Comments Name Comments Alert A1 Phone P2 Email Not started The comment column gets the value from the below table Name subname value Alert A1 1 Alert A2 0 Alert A3 0...

I'm new to VBA scripting trying to write a condition for the table, The condition is to take the fail status and loop through the same table and find if the appropriate ID has a pass status, if yes i need to delete the record, if no i have to retain the fail status. so my output will be i...

Set SumRange = ReconWS.Range(Cells(2, AmountFilter), Cells(ReconRows, AmountFilter)).SpecialCells(xlCellTypeVisible) If Application.WorksheetFunction.Sum(SumRange) = 0 Then ReconWS.Range(Cells(2, MatchedItem),Cells(ReconRows,MatchedItem)).SpecialCells(xlCellTypeVisible).Select...

The following VBA converts PDF file to excel. But i need some modification with it, At address A2 path of PDF file is entered and at B2 type is selected like .xlsx. When convert button is pressed it converts PDF to excel at same location. Now what i want with this code to be modified is that: 1)...

I have two buttons in my workbook, they perform different operation by importing data from same workbook but different sheets. I want to combine this into one button, please help me with this. Button 1 Code is: Private Sub CommandButton1_Click() 'Sheets("RawDataChamla").Visible = True...

Good Afternoon, I'm trying to modify my current code to replace specified words in a MS Word document. The whole idea is working but only for the body of the document and nothing happens in the header neither in the footer. Can you please advise me where am I wrong ? Thank you in advance...

I have a workbook with different sheets, when i try to clear some ranges through vba code, it gives me error, please help me with this. Private Sub CommandButton5_Click() Range("B13:F13").Select Range(Selection, Selection.End(xlDown)).Select Selection.ClearContents...

I need to copy data from one sheet to another by following these conditions: 1) User should select/browse for a file, from the opened file, it copies data from column A to Column D from sheet1 2) Column A has unique numbers while column C & D has duplication, it should ignore duplicate.it...

I need a VBA code for a button which when clicked browse for other excel file, search for specific sheet named “Farmer History” in it. In this sheet it looks for A1 complete row and search heading “Crop Area” and copy this column data to main file(where button embedded) in sheet named “Berkhund”...

The smart view for office com addin keeps disappearing from the Excel ribbon . Tried inserting the addin location in the trust center , also changed regedit to aways loaded value 3 . But nothing works , it disappears Everytime. We are doing an automation RPA project which needs the...