Userform error when other workbook open

[rhombus4]

I have a userform which I open in workbook1, sometimes while the userform is open I need to access a different workbook.

Problem Is when I try and enter data in workbook 2 I get Run-time Error '424' Object required"

I do have worksheet calculate event in the userform, is this what is causing the error or could something else be an issue

i.e.

Private Sub ws_Calculate()
Me.Textbox1 = ws.Range("myrange").Text
End Sub

Do I need to add thisworkbook or userform1 or something similar in the code.

I already have it as modeless when the userform is opened

 

[Norie]

Where are you defining/setting ws?

 

[rhombus4]

In the Userform Code at the top I have

Private WithEvents ws As Excel.Worksheet

Then in Private Sub UserForm_Initialize()

I have

Set ws = ThisWorkbook.Sheets("Data")

 

[rhombus4]

Where are you defining/setting ws?

Do I need to use in a specific place

 

[rhombus4]

Bump