Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,560
Default ComboBox index

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
fill combobox depending on selection from another combobox Adam Francis Excel Discussion (Misc queries) 2 July 24th 08 07:39 PM
ComboBox list reliant on the entry from a different ComboBox ndm berry[_2_] Excel Programming 4 October 4th 05 04:40 PM
ComboBox,Array and Index numbers Dennis Hightowe Excel Programming 4 May 26th 05 03:10 PM
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox Minitman[_4_] Excel Programming 3 October 26th 04 07:58 PM
Accesing a combobox control via it index propertie in VBA, Is itPossible? Muxer Excel Programming 3 July 30th 03 08:20 PM


All times are GMT +1. The time now is 07:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"