Solved: Getting the Selected value of a combobox

[Marcke]

I have a combobox dropdownlist, with choices 01-Title to 09-Title.

I wanted to get the selected value in another procedure, so i tried:
shSetup.Range("rStream").Value = frmMenu.cmbStream.SelText
I also used the value or text properties, and outputted them through a messagebox to check the contents, and they were all empty.

What should I do?

[lucas]

Try this:

Is it on a userform........I must assume it is since you qualify it with frmMenu. Is the combobox cmbStream?


MsgBox cmbStream.Value

[Marcke]

Hi, when I run this command in the buttonclick event it seems to work. Quite strange, but I can bypass this in this way, no problemo :)

Thanks for the help.