View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Roger on Excel Roger on Excel is offline
external usenet poster
 
Posts: 249
Default 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?