Loop Through UserForm For Multiple Different Outputs
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
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?
.
Relevant Pages
- Re: How do I obtain user input while running a macro
... you can use a user form anywhere in code - you just need to know ... Sir John Harvey-Jones "John" wrote in message ... > Unless I have several user input values, I simply use either a MsgBox ... I only use a userform for more complex user> interaction. ...
(microsoft.public.project) - Re: Help: Want to create multicolumn userform that accepts user inputs
... a userform in Project or Excel? ... The simplest method (although not ... that effectively locks out user input. ...
(microsoft.public.project.vba) - Re: create/chaning forms and objects from code
... based on user input (ie if the user fills in a number then I want to create ... if it's not possible in UserForm ... Handbuch". ... But obviously, that's in German, so not much use to you... ...
(microsoft.public.word.vba.general) - Re: clearing data from a userform
... Doug, thanks for the response. ... each control name in the userform view code screen, ... when I activate the template a second time. ... cursor does not appear in the first field for user input, ...
(microsoft.public.word.vba.userforms) - Re: Loop Through UserForm For Multiple Different Outputs
... Maybe this sample from Debra Dalgleish's site will help: ... You may want to look at data|form (in xl2003 menus) to see if that's sufficient, ... I have a UserForm that I want to repeat so I can get different user input. ...
(microsoft.public.excel.programming) |
|
