 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2006Help with ComboBox
Hi, I'm using Excel 2003 I have a spreadsheet using a ComboBox that allows selection of one of several sets of data. Each set is a 3 column row of data. I have the following properties set: BoundColumn: 2 TextColumn: 1 When a selection is made the ComboBox displays the column 1 value. The ComboBox seems to behave normally, except that when I close and open the file the combox initially displays the value of column 2 (instead of column 1). When a new selection is made it goes back to displaying the column 1 data. Shouldn't it always display the data as assigned by TextColumn (column 1)? How can I force it to? Thanks, -John John, Try setting your column count property to 1. > Hi, > [quoted text clipped - 21 lines] > > -John Jim, Thanks, I tried - and it still doesn't work Also, I wanted the 3-column rows of data visible in the drop down box. When the file is first open it displays properly for a moment then the value changes as I described. It must be doing some evaluation at start up. -John > John, Try setting your column count property to 1. > [quoted text clipped - 26 lines] >> >> -John John, I have an active X combo box directly on the worksheet and it was acting like you describe.. I had col 1 as text col and col2 as bound, but sometimes i would open the workbook and col 2 displayed in the box. I tried forcing down the ColumnCount to 1. I continued getting box displaying a blank when opened the workbook. Since then, I have increased the ColumnCount to 2. I set the Column Widths to 75,0, and it seems to have stopped. As you want all 3 columns to show in the dropdown, I would suggest ColumnCount 3 and set ColumnWidths for each column and see if that helps. Jim > Jim, > Thanks, [quoted text clipped - 36 lines] > >> > >> -John |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.