Run-time error 1004 - Method 'Range' of object'_Global' failed

Hi guys, would really appreciate your help!

How can I change this section of code for my search function, to show a msgBox with YES and NO option to create a new record when my ListBox3 is empty when searching, i.e., it finds no possible match?

Please Login or Register  to view this content.

Normally, I would simply create a new record on the UserForm without using the search function, but since I have the search function there is an error when I click my Save Entry button: Run-time error 1004 - Method 'Range' of object'_Global' failed.

I am sure the issue lies in this: my module3 has code specifying a range, and my Save Entry button has code for a range....

I would like to use both features of creating records....

Thanks for all help!

Hi..

Change the following Sub to:

Please Login or Register  to view this content.

And as for the error.. it was error because iRow was not getting passed a Value because no Autofilter had taken place (thereby it was bypassing the code in the FirstVisibleValue Function)..

Change the first part of your btnSave_Click Sub to this.. that should fix that...

Please Login or Register  to view this content.

apo - you rock! Thanks for the help - works great!

Hey.. Thats great it works for you... btw.. the Wallabies rule!

Yes, bud... As an avid Springbok supporter, I might not share your sentiment for the Wallabies, but as a friend a feel sorry for the proper ***-whipping the Allblacks gave you today.... C u when we play u