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?

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


--


Gary


"Roger on Excel" wrote in message
...
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?

Thanks - works fine now

Roger

"Gary Keramidas" wrote:

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


--


Gary


"Roger on Excel" wrote in message
...
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?