Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cont' Value and Text Property of Combobox
Sorry Tom, didn't mean to mislead you, I actually have setted them in design
mode, and not in code (the code was used initailly, 'cause I got few comboboxes doing the same thing, but different database, they were then changed to comment). Regards Augustus "Tom Ogilvy" wrote: You are correct (and I misspoke with reference to this specific situation). the boundcolumn corresponds to the value property and the textcolumn corresponds to the text property. However, if you are setting the boundcolumn and textcolumn in code, then these settings are non-persistent. Set them in design mode using the properties window and they should remain. -- Regards, Tom Ogilvy "augustus" wrote in message ... Tom, But why is it that we can specify them with different value initially? Example, Sheet1.cbxStructType.Clear Sheet1.cbxStructType.BoundColumn = 1 Sheet1.cbxStructType.ColumnCount = 2 Sheet1.cbxStructType.ColumnWidths = "0;30" Sheet1.cbxStructType.TextColumn = 2 Do While Not RS.EOF Sheet1.cbxStructType.AddItem RS.Fields("StructID").Value Sheet1.cbxStructType.List(Sheet1.cbxStructType.Lis tCount - 1, 1) = RS.Fields("StructDescrip").Value RS.MoveNext Say Row 1, Column 1 = Me, and Column 2 = You This will give me Value=Me, and Text=You Even after I save the file, this will remain the same (I checked under Design mode). However, the moment I close and reopen this book again, the Text will change to Value. Regards Augustus "Tom Ogilvy" wrote: for an activeX combobox, the value and text properties are identical. they should always produce the same output. -- Regards, Tom Ogilvy "augustus" wrote in message ... Hi, I got a spreadsheet with comboboxs connected to a database. Each combobox basically load two columns of data: One for displying to user, another to be store in database. However, everytime I save the spreadsheet, and load it up again (when I can't finish the work), the Text property get changed to the value in Value Property. WHY? Is there way to prevent this? Running Win2000 & Office2003. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set text property of a check box to value of a cell? | Charts and Charting in Excel | |||
problem not solved... CONT.IF depending on the text color | Excel Discussion (Misc queries) | |||
Value Property vs Text property | Excel Programming | |||
Runtime error 380: Could not set the List property. invalid property value of listbox | Excel Programming | |||
no tab index property in VBA for text fields | Excel Programming |