$$Excel-Macros$$ Re: Class Module Events

2011-11-26 Thread Sam Mathai Chacko
Check if your class is initializing at all. You can do that by adding this sub in your class module. If this is not working, then your class isn't initializing at all. Private Sub Class_Initialize() MsgBox "Hi" End Sub Sam Mathai Chacko On Nov 26, 2:55 pm, Mahess Desai wrote: > Hi! > > I f

$$Excel-Macros$$ Re: Class Module

2009-09-30 Thread Dilip Pandey
Hi Jai, If you know these function without VBA, then you easily understand and use below codes: Sub vlookup() Range("d9").Formula = ("=vlookup(c9,a:b,2,0)") End Sub Sub hlookup() Range("h5").Formula = ("=hlookup(h4,1:2,2,0)") End Sub A Workbook is also attached with the required VBA code. Thank

$$Excel-Macros$$ Re: Class Module

2009-09-30 Thread Jai Deo Tiwari
Hi everyone, Please tell me how to use v-lookup and h-lookup using VBA. If possible please attach the docs of example. > > > > -- Regards, Jai Deo Tiwari, Rewire Information Systems Indiranagar, Bangalore - 38 Mob # 09620346991 . Notice: The information contained in this e-mail message