Keeping userform in "Range"

[fredrerik84]

Good morning mr excel community

I have made a userform which I was hoping to keep open trough the day in the memory , but when I click out of excel and start browsing , when I come back to excel and try to do something with the userform I get error with the worksheet like this:

 Dim ws As Worksheet: Set ws = Worksheets("Data")

- run time error , subscript out of range


Is there a way to prevent this ?

regards

frederik

 

[dmt32]

Hi,
Try qualifying the worksheet with the ThisWorkbook Property & see if this solves your problem.

Dim ws As Worksheet: Set ws = ThisWorkbook.Worksheets("Data")

Dave

 

[fredrerik84]

Hi thanks for your reply and tip.. I suspect this might work. I'll try it and update you

Frederik