Hi Alex!

Thank you for your help. These 2 are actually different files, so I wouldn't
be using them simultaneously. The problem with Data Validation is that I have
about 2000 items in my data base -- these will increase almost weekly, thus
using Data Validation hasn't been working for me at the moment, as I still
have to look through many items to choose from them.

Is there any other way to apply the "find as you type" property to the drop
down menu?

I used the code you sent for the counter, and it worked wonderfully,

Thank you!

~~ Kolia

wrote:
Hello there

#1
I would rather use the validation from the data menu in Microsoft Excel
which allows you to create a combo-box rather to create a combo with VBA. If
you have a lot of code written which filters automatically the entries this
will be very slow. Better it is to sort the data for the combo-box and if
you type it will jump automatically to the letter but you still have all
entries in the combo-box. Try first with the validation from the Data menu
and if this is not enough please answer.

#2
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Range("A1").Value = Range("A1").Value + 1
End Sub

You can change the cell "A1" to any desired cell.

Kind regards,
------------------------------------
Alex
www.excelspezialist.ch
------------------------------------

Hi! I need help with two excel questions. I'm just starting to use excel
macros and such, and right now I need to create a combobox that will "fill
[quoted text clipped - 23 lines]

Thank you!!!

--
Message posted via http://www.officekb.com