error checking a userform dropdown box

[scouse13]

hi guys, I have a userform with some dropdown boxes for a user to choose a Month no, which when chosen data is copied from one sheet to another which all works fine, I was wondering if anyone had any code that I could use, so if a user chose say month 10, but data in the records sheet does not exist for that month then a message box appears asking the user to choose a different month number and the code is stopped, Month numbers are stored in column Z on the records sheet.

many thank

scouse13

[Sintek]

Not sure of your setup as no sample file attached...This will give you an idea

Please Login or Register  to view this content.

[scouse13]

Thanks for the reply sintek, below is the code from the command button that copies data based on the combobox selection (the combobox is pre-populated from a list on a different sheet - there is no code behind the combobox), if I can try to explain again, the user would pick a number from the combobox and then press the command button to copy the data, what I need to happen is when the selection is made in the combobox, code runs to see if that number exits in the records sheet, is so the user presses the command button if it does not exist then a message box appears asking them to make another selection, hope this makes it a bit clearer
scouse13

Please Login or Register  to view this content.

[Sintek]

And why have you posted the CommandButton code?

what I need to happen is when the selection is made in the combobox, code runs to see if that number exits in the records sheet, is so the user presses the command button if it does not exist then a message box appears asking them to make another selection, hope this makes it a bit clearer

This was clear from the beginning...Post 2 code solves that...Just incorporate it into your ComboBox that the user makes selection from...

Please Login or Register  to view this content.

Change Red 1 to your ComboBox No...
Change Green Z to the column you want to search...
If you do not know how to incorporate then I suggest you upload a sample file...

[scouse13]

hi sintek, tried that code again in the combobox, it does not matter what number is selected the message box appears, in the records sheet I have records that in column z are showing as 1 and 5, , so selecting 1 or 5 in the combobox should just run the code, and if I selected 3 this should show the message box.

ie the code should check the records sheet column z and confirm the numbers are in there.

scouse13

[Sintek]

Works for me...I cannot test scouse13 as I do not have a sample file of your setup...
In future always supply a sample...That way your query can be solved correctly...3rd time I've mentioned sample file...

EDIT...Here's another method

Please Login or Register  to view this content.

[scouse13]

Hi sintek thanks for your help, I played around with your file / code you sent, and have got it working the way I need,
have re-attached the file so if anyone else has the same same problem the answer is available.
thanks again for your help.
scouse13

[Sintek]

Glad you got it sorted...Tx for rep +
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.