Userform - need to access data from a particular sheet

  • Thread starter Thread starter Roger on Excel
  • Start date Start date
R

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?
 
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
 
Thanks - works fine now

Roger

Gary Keramidas said:
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
Click to expand...
 
Back
Top