hi,
is there any way to get the value for the selected item from the combo box in vba code?
thanks =)
hi,
is there any way to get the value for the selected item from the combo box in vba code?
thanks =)
Re: Selected Item From The Combo Box
Quote from aliahi,
is there any way to get the value for the selected item from the combo box in vba code?thanks =)
alia, could you be more specific.
where is the combo box, on a spreadsheet or user form?
what do you want to do with the value?
if you can elaborate forum users may be able to better answer your question
this code assumes your combo box is in a user form, and takes the value selected from the combobox and writes it to Cell A1 of the active spreadsheet.
Hope it helps
Re: Get/Determine Selected Item In ComboBox
hi,
Sorry if my explanation was unclear. The combobox is on a userform.
Thing is, with the value of the combobox, will open a worksheet.
I guess what i should have asked was..
1) Is there a way to not allow the user to key in any values in the combobox?
2) Is there a way to check if the user have made a selection in the combobox? Coz a selection MUST be made..
With cboTech
.AddItem "SP25"
.AddItem "SP18F"
.AddItem "SP15"
.AddItem "SP14F"
.AddItem "ST25"
.AddItem "ST22"
.AddItem "ST18"
.AddItem "ST16"
.AddItem "ST15"
End With
Display More
thanks again =)
Re: Get/Determine Selected Item In ComboBox
To stop user entered information use
[vba] .Style = fmStyleDropDownList[/vba]
Re: Get/Determine Selected Item In ComboBox
hi,
thanks guys..juz wat i needed.. =)
alia
Don’t have an account yet? Register yourself now and be a part of our community!