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