Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to create screentip for a custom function?
In Excel 2007, when you typed "=sum(" a screentip will popup "SUM(number1, [number2] .." Can you define your own screentip for your custom function? Many thanks!!- jchanw
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Application.HLOOKUP to an external file
This is great!! Thanks!!- jchanw
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Application.HLOOKUP to an external file
I would like to create a customize HLOOKUP function (which replicate what a normal HLOOKUP function does but take on 2 lookup values and arguments such as the file path and filename). This is what I can do in Excel: =HLOOKUP(E3,'C:\temp\[file.xls]sheet'!$C$1:$M$1000...- jchanw
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
