Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Excel ActiveX listbox controls
Hi! I’m trying to create listboxes that displays data from a named range spanning multiple columns. I am able to populate the listbox with data and use it without any problems. However, if the sheet that contains the listboxes changes, the size/dimensions of the listbox unexpectedly also changes. Since I have not written any procedures that control the height/width properties of the listboxes, I cannot determine why the dimensions of the listboxes are changing. I have attached a spreadsheet that illustrates this problem. When you open the spreadsheet, you should see two listboxes named ListBox1 and ListBox2, which refer to the “A” dynamic named (G1:H6) range and “AA” dynamic named range ((J1:K6) respectively. Now, if you make any type of change anywhere on the worksheet (e.g. enter any value in cell C1), the dimensions of Listbox2 changes but not the dimensions of Listbox1. Why? By the way, the problem does not seem to be related to named ranges: the error occurs even if you set the ListFillRange to a fixed cell range. Thanks for your help. Amit +-------------------------------------------------------------------+ |Filename: listbox problem6.zip | |Download: http://www.excelforum.com/attachment.php?postid=3581 | +-------------------------------------------------------------------+ -- programmer123 ------------------------------------------------------------------------ programmer123's Profile: http://www.excelforum.com/member.php...o&userid=25011 View this thread: http://www.excelforum.com/showthread...hreadid=385396 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activex controls in Excel 2003 | Excel Worksheet Functions | |||
Help with Excel ActiveX listbox controls | Excel Discussion (Misc queries) | |||
Saving Excel with ActiveX controls | New Users to Excel | |||
Tab between ActiveX controls on an Excel worksheet | Excel Programming | |||
ActiveX Controls on Excel sheets | Excel Programming |