Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / January 2008

Tip: Looking for answers? Try searching our database.

Lookup in VBA

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bill Martin - 24 Jan 2008 21:59 GMT
I was about to embark on moving some VLOOKUP type code into a VBA module
using the "WorksheetFunction" approach.  First however, I thought I'd check
whether there was an easier, more direct approach.

Following my nose, I find the VBA development help system provides a list of
available native VBA functions which include LOOKUP so I don't have to mess
with the "worksheetfunction" approach.  Wonderful.

I follow the VBA help system for syntax and plug it into a VBA module.  VBA
provides a compile error though "Sub or Function not defined".

What's going on?  The VBA help system helpfully describes the function but
the compiler does not recognize it.  Do I need to link to something?  I've
never stumbled across such a thing in VBA before.

Thanks.

Bill
Bill Martin - 24 Jan 2008 22:08 GMT
Now I understand.  I misread the Help system.  Moving right along...

Bill
----------------
>I was about to embark on moving some VLOOKUP type code into a VBA module
>using the "WorksheetFunction" approach.  First however, I thought I'd check
[quoted text clipped - 14 lines]
>
> Bill
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.