$$Excel-Macros$$ Outlook VBA code to send email notification on a specific date criteria

Dear VBA champions, I need a quick help. I would like to send automated notification to few individuals on certain dates. When the criteria date arrives, once I launch Outlook, an automatic email should be sent to the recipients. Let me know if it is not clear. Thank you, Sharath -- Are y

$$Excel-Macros$$ Need help on data validation: List

Hi, I am looking for some help on data validation. If the value in cell A1 is Global B1 should display a dropdown list. If the value is Local, B1 should be left editable to the user to enter value of their choice. I appreciate your help. thank you, Sharath -- Are you =EXP(E:RT) or =NOT(EXP(

$$Excel-Macros$$ VBA code required to export rows in spreadsheet to SharePoint list

Hello Friends, I need help in building a code that enables me to export rows from Excel worksheet to a SharePoint list. Please see attached. I inserted a button. Once the button is clicked, data in row 2 should copy over to SharePoint list. On the SharePoint list a new item should be appended.

$$Excel-Macros$$ Need quick help to extract rows that meets a search criteria

Hello, I have a set of 51 unique names. I want to extract rows that contain any one of the 51 names. Please help. Thank you, Sharath -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles,

$$Excel-Macros$$ Unable to open other Excel Files when using VBA form

Hello Experts, We have created a VBA form. When we have the form open, we are unable to open any other Excel workbooks. Is there any way where we can enable multiple instances parallel to VBA form? Thank you in advance. Regards, Sharath -- -- FORUM RULES (986+ members already BANNED for vi

$$Excel-Macros$$ Need a VBA code to display name in "Last Name, First Name" format

Hello Experts, I have attached a spreadsheet. In Column F we have a name. By default it is validated in the format "First Name (and Middle Name if exists) Last Name". So when someone types in a name in any of the cell in Column F, it should convert the format to "Last Name, (comma) First (and M

$$Excel-Macros$$ Re: Need a VBA code

uot;)(0) > End Function > > Regards, > Lalit Mohan > > On Wednesday, 27 June 2012 15:21:32 UTC+5:30, sharath chandra wrote: > >> >> Hello Experts, >> >> I need a quick VBA code. We have column where we enter a name in "First >> Name Las

$$Excel-Macros$$ Need a VBA code

Hello Experts, I need a quick VBA code. We have column where we enter a name in "First Name Last Name" format. When someone enters a name in that cell, it should automatically display the name in the same cell in the "Last Name, First Name" format (which is Outlook format). Please let me know