$$Excel-Macros$$ Open Internet Explorer automatically from Excel

Hi All, I am using the following portion of a code to open the Internet Explorer from Excel Sub OpenIE() Dim IE As Object Dim frmT As Object Dim doc As Object Dim opt As Object Dim ws1 As Worksheet Dim drop As Integer Set ws1 = Worksheets("Check") Set IE = CreateObject("InternetExplorer.

$$Excel-Macros$$ Re: VBA Form Auto Sizing

Hi Ashish, Thanks for being there While I try to reexplain. FormSource is a defined name of Cell A1, which contains a list a values DataS1 DataS2, DataS3 and Datas4 Dimensions is a defined name of range containing values for height and width of the Form. I just want to know how to as

$$Excel-Macros$$ Re: VBA Form Auto Sizing

A little help and I would be done.. Thanks again On Mar 12, 10:07 pm, kanwal_no1 wrote: > Hi Ashish, > > A little help and I would be done.. > > Rega

$$Excel-Macros$$ Re: VBA Form Auto Sizing

Hi Ashish, A little help and I would be done.. Regards Kanwaljit --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text),

$$Excel-Macros$$ Re: VBA Form Auto Sizing

Hi Paul, ThanksUnload the Form Ok working now. FormSource is a defined name of Cell A1, which contains a list a values DataS1 DataS2, DataS3 and Datas4 Dimensions is a defined name of range containing values for height and width of the Form. I just want to know how to assign the values

$$Excel-Macros$$ Re: VBA Form Auto Sizing

Hi Ashish, Thanks a lot ! But I am afraid, it is not working... Just want to mention that I put the following code in the sheet1 Private Sub CommandButton1_Click() MyForm.Show End Sub Private Sub Worksheet_Change(ByVal Target As Range) MyForm.Height = "=HLOOKUP(FormSource,Dimensi

$$Excel-Macros$$ Re: VBA Form Auto Sizing

Hi Ashish, One more thing... How to exit the form whenever I deactivate the sheet or How to exit the form whenever I close the workbook --~--~-~--~~~---~--~~ - Some important

$$Excel-Macros$$ Re: VBA Form Auto Sizing

Hi Ashish, I still need some help with that On Mar 8, 5:18 am, Ashish Jain <26may.1...@gmail.com> wrote: > Ya Kanwal - I've received your file. > > On Mar 7, 2:41 am, kanwal_no1 wrote: > > > Hi Ashish, > > > Have you got

$$Excel-Macros$$ Re: VBA Form Auto Sizing

Hi Ashish, Have you got the file ? Regards Kanwaljit --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloa

$$Excel-Macros$$ Re: VBA Form Auto Sizing

Here is the file. named "VBA form auto resizing.xls (2)" http://groups.google.co.in/group/excel-macros/files?&sort=date Kanwaljit On Mar 6, 12:05 am, kanwal_no1 wrote: > Hi Ashish, > > I tried the code, but it is not working the way it should.. I have > u

$$Excel-Macros$$ Re: VBA Form Auto Sizing

er - Excel and VBA > Author ->www.excelitems.com > 0-40-48-43 > > ---- > > On Wed, Mar 4, 2009 at 12:25 PM, kanwal_no1 wrote: > > &

$$Excel-Macros$$ VBA Form Auto Sizing

Hi Everyone, Regards... This is my 1st post to this group. I have a User Form which needs to take a specified size depending upon the data source. Data Source is in Range DataS1 and DataS2. The following range (named as "Dimensions") shows the dimensions which the User Form needs to have