Thread: Loop Through UserForm For Multiple Different Outputs
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Loop Through UserForm For Multiple Different Outputs
Maybe this sample from Debra Dalgleish's site will help:
http://contextures.com/xlUserForm01.html

You may want to look at data|form (in xl2003 menus) to see if that's sufficient,
too.

gims289 wrote:

I have a UserForm that I want to repeat so I can get different user input. I
want the input from the UserForm to write into a spreadsheet, then re-open
the UserForm to get different user input and display after the previous
input.

Does anyone know of a way to pause the code while the UserForm is being
populated, then have the code continue from where it left off?

--

Dave Peterson
Reply With QuoteReply With Quote