Userform - need to access data from a particular sheet

[Roger on Excel]

I use a personalized Userform to edit data on a "Summary" sheet. The userform
collects data from the sheet so it can be edited.

The Userform works fine on the Summary sheet, yet when I activate the form
from another sheet it selects cells on that sheet rather than the Summary
sheet.

How do i make the userform read data from the Summary sheet when I activate
it on another sheet?

Can anyone help?

 

[Gary Keramidas]

either activate the summary sheet so it gets the correct data or fully qualify
the ranges that populate the form,

for example, instead of
me.textbox1.value = range("A1").value

use
me.textbox1.value = worksheets("Summary").range("A1").value

 

[Roger on Excel]

Thanks - works fine now

Roger

either activate the summary sheet so it gets the correct data or fully qualify
the ranges that populate the form,

for example, instead of
me.textbox1.value = range("A1").value

use
me.textbox1.value = worksheets("Summary").range("A1").value