View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Geoff C Geoff C is offline
external usenet poster
 
Posts: 40
Default Quick Form for updating a range?

I have a template containing several lookup lists (some 2 column, some 3
column) that are hidden. Is there a quick way to make a userform that allows
a user to update the lookup values? Ideally it would display the whole range
at once. I've tried ShowDataForm using a range, but it's not quite what I
had in mind.

Thanks,
Geoff.