ComboBoxes - check if a value is selected.

[Pacman52]

Hi all,

Using 1 combobox as an example (there are multiple copies of it).

So I have cmbProd1 and txtQty1.

Once a user selects an item in the combobox list the focus moves to the quantity textbox and the quantity textbox checks for any value that is NOT numeric in the BeforeUpdate sub - this works fine.

What I'm trying to sort now is the Exit sub to check if the combobox has an item from the list selected then the quantity box can not have a number lower than 1.

I'm ok on sorting the number check but what I can't workout is how do I check the combobox has a value to be able to check if a number in the quantity box is required?

I've tried various methods to check the combobox ...listcount, value, >"", ect ect bout nothing seems to work - the code below is a rough test

Thanks for any help offered. Paul

Private Sub txtQty1_Exit(ByVal Cancel As MSForms.ReturnBoolean)


If Not IsNull(ComboProd1) And Not IsNumeric(txtQty1.Value) Or txtQty1.Value = "" Then
MsgBox "nothing"

Else

MsgBox "something"

 

[dreid1011]

This may help: https://stackoverflow.com/questions/21038462/how-to-determine-if-any-row-is-selected-in-a-listbox

Or this since I did not look for combobox the first time: Check if Combobox has a value selected

 

[Pacman52]

Hi thanks so much for the reply. The second link you sent over did the trick thankfully.

I had already tried the listindex option but did realise it needed to be '-1' and if I'm honest I still don't understand why but its working now so I can move forward with the workbook.

Thanks again Paul

 

[dreid1011]

Hi thanks so much for the reply. The second link you sent over did the trick thankfully.

I had already tried the listindex option but did realise it needed to be '-1' and if I'm honest I still don't understand why but its working now so I can move forward with the workbook.

Thanks again Paul

You're welcome, and happy to help.