excel code

i need a vba code then help me read the body text outlook inbox if the body text is (please file) then move specific email into the folder ie C:desktop/dummyfolder/

I need to copy set of rows from SrcWrkBook to DestWrkBook if a condition is achieved. In Source workbook (SrcWrkBook) , if column B has a number in such a case that entire row excluding column K,N and O should be copied to destination workbook (DestWrkBook ). In some of the rows, column B has...

Hi How can you auto highlight in userform the last entered item? This is the code I'm using to auto-select the last item entered. Me.lstDatabase.TopIndex = Me.lstDatabase.ListCount - 1 Me.lstDatabase.BackColor = RGB(153, 153, 255) ? Thank You!

I have an excel spreadsheet that is a checklist and once items are complete i would like the users to double click the cells and it stamp their initials and the date. I have seen others ask the same thing and they have come up with code to pull the username and date which is working for me but i...

Is there a way to take input(email-id) from the user and automatically mail the same excel sheet using vba code ? any help would be greatly appreciated.

Is there a way to create a macro for a 3500 line excel file to take the prepopulated weblink, paste into a web browser and then grab a 10 digit code that is always in the same spot? The data I want to grab is also visible when looking at the data in chrome source, so the grab could be like find...

Hello All, First time post here. I have created a document which has a list box on the summary page in which items can be chosen. There are three tabs I have created for these options. Examples of list drop down information: Fred, George, Liz, Fred & George, Fred & Liz, George & Liz, Fred &...

Hi, I have Windows 7 and using Excel 2010. I am using this code to prompt for additional info when an entry is made in the file. Currently it is asking for an entry for the next box. I need it to ask for an entry for the next 3 boxes too but cannot figure out what to add. Option Explicit...

I have this code that brings up a comment box in column B (to type something that would show in column B) whenever I type something in column A. Now I need this in a domino effect up until column D. This is the code: Private Sub Worksheet_Change(ByVal Target As Range) Dim myComment As...

I have been viewing different codes over the internet for 4 days and I can't seem to get this to work correctly. I have a named range called "REVBUD" and when selecting any cell within that range, the amount selected is supposed to paste so a table called budget. It does paste but when I go to...

Hi Guys, I am new here and i wanted to know something about VBA. I was searching for a questions on internet about how to open multiple links from excel with single click. FOr example openining 10 links in new tabs in firefox or chrome using the VBA Code. I found my answer at MREXCEL. But I...

Hi All I'm trying to put a info sheet to let people know about current stocks and time we have left of each product. I have estimated weeks of stock left as shown below (Cover in stock, cover on way, factory cover, store cover. I want the sheet to colour in cells along a row depending on...