Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks Tom, this worked for me.
So what is the deal? Label1.Caption = Combo1.Value only works with excel visual basic? cause the above worked in excel vb but not in vb6.0 Thanks "Tom Ogilvy" wrote: Private Sub Command1_Click() With Combo1 Label1.Caption = .list(.ListIndex) End With End Sub assuming that Combo1 is the name of your combobox. -- Regards, Tom Ogilvy "David" wrote in message ... Hi bob I tried this before and I get the following error: "method or data member not found" and ".Value" is highlighted. do I need to set something up in the comboBox properties first. In the comboBox properties, where should I enter items, in "List" Field or "ItemData" Field Thanks "Bob Phillips" wrote: Private Sub Command1_Click() Label1.Caption = Combo1.Value End Sub -- HTH Bob Phillips (remove nothere from email address if mailing direct) "David" wrote in message ... Hi, I am new to VB, I created a comboBox using VB and included 3 items in it I created a command button and a label button. I would like to display selection from comboBox into the label box when I click on the command button. I am using the following code but I keep getting the first value entered in comboBox. Does the index or ListIndex the one that gets updated with the value selected from the combo box? I need to save that value to do some math with it but before I do that I want to make sure that it is in fact the last selection. Private Sub Command1_Click() Label1.Caption = Combo1.ItemData(Index) End Sub Private Sub Label1_Click() End Sub Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
ComboBox list reliant on the entry from a different ComboBox | Excel Programming | |||
ComboBox,Array and Index numbers | Excel Programming | |||
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming | |||
Accesing a combobox control via it index propertie in VBA, Is itPossible? | Excel Programming |