Re: $$Excel-Macros$$ get data from list and display it in msgbox

2012-01-05 Thread NOORAIN ANSARI
ftware > dguille...@gmail.com > -Original Message- From: Seba > Sent: Thursday, January 05, 2012 6:55 AM > To: MS EXCEL AND VBA MACROS > Subject: $$Excel-Macros$$ get data from list and display it in msgbox > > > Hi, > > I need help with the getting the data from a

Re: $$Excel-Macros$$ get data from list and display it in msgbox

2012-01-05 Thread dguillett1
_ MatchCase:=False, SearchFormat:=False) If Not mf Is Nothing Then MsgBox mv & " is " & mf.Offset(, 1) End Sub Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Seba Sent: Thursday, January 05, 2012 6:55 AM To: MS EXCEL AND VBA MACROS Subject: $

RE: $$Excel-Macros$$ get data from list and display it in msgbox

2012-01-05 Thread Rajan_Verma
.Transpose(rngList), vbNewLine) MsgBox strResult End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Jan/Thu/2012 06:38 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ get data from list and display it

Re: $$Excel-Macros$$ get data from list and display it in msgbox

2012-01-05 Thread Seba
I can't thank you enough:) It works like a charm! best regards, seba On 5 jan., 14:07, NOORAIN ANSARI wrote: > Dear Seba, > > Please see attached sheet, Hope it will help you > otherwise pls share your workbook with group. > > > > > > > > > > On Thu, Jan 5, 2012 at 6:25 PM, Seba wrote: > > Hi,

Re: $$Excel-Macros$$ get data from list and display it in msgbox

2012-01-05 Thread NOORAIN ANSARI
Dear Seba, Please see attached sheet, Hope it will help you otherwise pls share your workbook with group. On Thu, Jan 5, 2012 at 6:25 PM, Seba wrote: > Hi, > > I need help with the getting the data from a list and display it in a > msgbox. I don't wan't to do this via the ususal lookup functio

$$Excel-Macros$$ get data from list and display it in msgbox

2012-01-05 Thread Seba
Hi, I need help with the getting the data from a list and display it in a msgbox. I don't wan't to do this via the ususal lookup functions in excel, because I'd like to avoid moving around the worksheet too much. Would it be possible to get a macro to do the following: 1. Open a inputbox to enter