Prev: NO justifying on final line.
Next: EULA
From: Gmann on 9 Feb 2010 12:13

Hi, I have some code that I am experimenting with in excel:

Private Sub ComboBox1_Change()
Select Case ComboBox1.Text
Case "Dogs"
MsgBox "Dogs"
Case "Cats"
MsgBox "Cat"
Case "Mice"
MsgBox "Mice"
Case Else
End Select
End Sub

Private Sub Worksheet_Activate()
ComboBox1.Clear
ComboBox1.AddItem "Dogs"
ComboBox1.AddItem "Cats"
ComboBox1.AddItem "Mice"
ComboBox1.Text = ComboBox1.List(0)
End Sub

When I link the output to a cell, it returns the word value, how can I
get it to return a number from 1-3, instead of the word values?
Thanks!




--
Gmann
 | 
Pages: 1
Prev: NO justifying on final line.
Next: EULA