Version Checking Subroutine help

[chinaboy]

Hi,

I found the code below which I believe will allow me to make sure the users are using the most up to date version of an Excel database. In the example from the post on the Ozgrid forum post here, the post mention that the version number should be placed in a .vi file, but can I just use a .txt file to store the version number? I asked for help from that post but was told I had to start a new post. So sorry for double posting this question. I continue to get a compile error. at "Call CKV" Sub or Function not defined.

I placed the code below in a module in the excel workbook.

Please Login or Register  to view this content.

I then put the code below in the the Sub userForm_Initialized of the userform. I continue to get a compile error. at "Call CKV" Sub or Function not defined. I can't seem to figure this out.

Please Login or Register  to view this content.

Can anyone help get this working on my excel worksheet.

[T-J]

I placed the code below in a module in the excel workbook.

I continue to get a compile error at "Call CKV" Sub or Function not defined.

You will get that error if Private Sub CKV(var1) is declared in another module and not in the Userform module.

Private means that procedure is accessible only to other procedures in the module where it is declared, therefore your Userform code won't 'see' it.

I would move Private Sub CKV(var1) to the Userform module if the code is changing properties of the Userform controls which it appears to be doing.

[chinaboy]

Thanks for you response. I moved the code to the userform and now I get compile error "Method or data member not found" at line ".tb_status"

Please Login or Register  to view this content.

[chinaboy]

Ok, I figured out what I did wrong. It's working like it should. Thank for your help.