Userform - need to access data from a particular sheet
 

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?

Userform - need to access data from a particular sheet
 

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?

Userform - need to access data from a particular sheet
 

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?