@excelvba

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

Hello ..!! This is my 3rd thread with Mr.Excel and my journey here is making me visualize what all can I automate using VBA and becoming successful with smaller macros for now. Thanks to everyone who is making my journey here fruitful ..!! :) So I am here with a request for macro that I need...

Hi There, This forum has been helpful to me from time to time ..!! Its helping me in learning as well as writing small automation. However, I am struck at this point in the automation I am working upon. It would be kind of anyone who could help me with this. Thanks a ton in advance...

i was try "Change Font Color Black to White After Found " 0" Value In E Column , And may be I hope Hide row According Zero value. ???" how to possible Conditional Formatting ????

Hi everyone, is there a excel vba code for fuzzy lookup that can return multiple values?

Hi All, I did an excel macro that will take the server logs from my outlook inbox and populate in excel sheet, in which my subject itself say on what date it ran, what job and the status(PASS/FAIL).Every thing is smooth here. But i wanted to take it further, for the failed emails we get logs...

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

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

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

Hello All, Can anyone help me in getting the code for below need I would like to send an email based on cell value , for example A2 cell consist of email address and in A3 I have conditions like "Yes" or "No" , if A3 consist of "Yes" excel should trigger a email to email address in A2 by...