$$Excel-Macros$$ Re: Hi I would require help on vlookup with search option

2009-04-05 Thread Gaurav Bansal
nice!!! On Fri, Apr 3, 2009 at 8:33 PM, Alpesh Juvarewala ajuvarew...@gmail.comwrote: Hi, Pls find the attached solution. The trick is to use wild card character. The limitation is that the text should not be repeated in any other cell or else the result may not be as per expectation.

$$Excel-Macros$$ Re: Connecting with yahoo finance servers

2009-04-05 Thread Ashish Jain
Hi vitovla, Use Exit keyword to break a process. You can use it to come out of Subroutine or a Loop. Its possible combinations are: Exit Do Exit For Exit Sub Regards Ashish Jain On Apr 4, 9:12 pm, vitovla slbcr...@gmail.com wrote: Hello, I'm developing an application to download the data

$$Excel-Macros$$ Re: UserForm objects/controls collections?

2009-04-05 Thread Ashish Jain
Hi Vincent It seems more like sharing information - and we dnt find any other way to do this at runtime. If you've plz share with us. Regards Ashish Jain On Apr 2, 6:09 pm, Yu vincent2...@gmail.com wrote: Hi Dear all,     I have this puzzle for a long time. I often program UserForm and

$$Excel-Macros$$ Re: UserForm objects/controls collections?

2009-04-05 Thread Dave Bonallack
Hi, I'm not sure if this would work with forms, but when I put multiple text boxes on a worksheet, I can change them all with the following code: ActiveSheet.Shapes.Range(Array(Text Box 1, Text Box 2, Text Box 3)).Select Selection.ShapeRange.Height = 84.75