Re: $$Excel-Macros$$ Share your Coolest VBA codes!

2009-11-24 Thread Hemant Hegde
Here is another code I wrote but could not make much use of it In the attached excel file, I have a frame inside a sheet which I wanted to be able to move by drag and drop... It is working fine. See if you can use that in you application -- -

Re: $$Excel-Macros$$ Share your Coolest VBA codes!

2009-11-24 Thread Hemant Hegde
Hi everyone Sorry for the delay: 'This is a function which I wrote for displaying and adjusting the form size for my project: Public Sub mZoom(ByRef Form As Object, Optional Hzoom As Integer, Optional Vzoom As Integer) If Vzoom = 0 Or Hzoom = 0 Then Hzoom = Application.Width / Form.Width * 100 V

$$Excel-Macros$$ Share your Coolest VBA codes!

2009-11-22 Thread Hemant Hegde
Why not we share some of our own useful codes or techniques (which can not be easily found by a google search) which will save lot of effort and time? :) I am going to post some of the vb codes I wrote or got on the net. I will post a function (tomorrow because I don't have it here!) I wrote which