Good Solution Don
On Thu, Jan 5, 2012 at 8:00 PM, dguillett1 wrote:
> Another way, using FIND, or use application.vlookup
>
> Sub GetData()
> Dim mv As Range
> mv = InputBox("Please enter a value")
> If mv = "" Then Exit Sub
> Set mf = Columns(1).Find(What:=mv, LookIn:=xlValues, _
> LookAt:=xlW
Another way, using FIND, or use application.vlookup
Sub GetData()
Dim mv As Range
mv = InputBox("Please enter a value")
If mv = "" Then Exit Sub
Set mf = Columns(1).Find(What:=mv, LookIn:=xlValues, _
LookAt:=xlWhole, SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False, Sear
.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
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,
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
