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

Hi, my pleasure Kanwal, Try this MyForm.Height = Application.WorksheetFunction.HLOOKUP (FormSource,Dimensions,3,FALSE) MyForm.Width = Application.WorksheetFunction.HLOOKUP (FormSource,Dimensions,2,FALSE) . . . . . For more tips, tricks, downloads and problem solutions: visit --> http://www.exc

$$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

- Hi Kanwal, Please re-explain your problem, if this link to excel file doesn't solve your problem. http://groups.google.com/group/excel-macros/attach/a6c9a594e4b3c30f/VBA+form+Auto+Resizing.xls?part=4&view=1 For mo

$$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.. > > Regards > Kanwaljit --~--~-~--~~~---~--~~

$$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

wal_no1 To: MS EXCEL AND VBA MACROS Sent: Wednesday, March 11, 2009 8:29:55 AM Subject: $$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()

$$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 Kanwal, Sorry for being late. Here is your Solution attached with the mail. It was more easy than before. By putting HLookup, you're half done already. Do tell us, if more help needed. Thanks and Regards Ashish Jain For more tips, tricks, downloads and problem solutions: visit --> http://www

$$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 the file ? > > > Regards > > Kanwaljit --~--~-~--~~-

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

Ya Kanwal - I've received your file. On Mar 7, 2:41 am, kanwal_no1 wrote: > Hi Ashish, > > Have you got the file ? > > Regards > Kanwaljit --~--~-~--~~~---~--~~ - Some im

$$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 > uploaded a file > herehttp://gro

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

Hi Ashish, I tried the code, but it is not working the way it should.. I have uploaded a file here http://groups.google.com/group/excel-macros/web/VBA%20form%20auto%20resizing%20%282%29.xls Infact the number of sets can increase. So what ultimately is desired that formwidth and Formheight are

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

Hi Kanwaljit, I've posted your solution, please check this link: http://www.excelitems.com/