Re: Input box based upon a list
- From: bryan <bryan@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 24 Oct 2007 11:57:07 -0700
I see now that I can use the UserForm inside another macro, although as
mentioned I do not need the info on the document, I will only use it in my
string of building the file name. If it needs to be on the form can I hide it?
Thanks,
Bryan
"Russ" wrote:
Bryan,.
See inline.
In reading the userform article, 2 thingsThe UserForm1.Show command can be issued from any module, the example at the
1) I would like the box to appear after I have selected my 'Save to IR' button
website just talks about using an autoexec subroutine, but you could issue
the command from your 'Save to IR' macro code.
2) I don't need or want this info on the documentLike a popup input box, a Userform is the Cadillac of information retrieval
dialogs and can be made simple or extravagant. The information gathered from
the user must be injected in the document by code, it doesn't automatically
appear into the document.
http://gregmaxey.mvps.org/Repeating_Data.htm
Maybe I leave as an input box?
Thanks,
Bryan
"Doug Robbins - Word MVP" wrote:
Then it sounds like what you need is a userform and I think that you perhaps
have the wrong idea about what that actually is.
See the article "How to create a Userform" at:
http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm
You would have a combobox on the userform that is loaded with the items from
which you want the user to make a selection.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"bryan" <bryan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:929E1561-636A-45C1-94D7-FBC875FC1A78@xxxxxxxxxxxxxxxx
Autotextlist is not what I'm looking for.
Upon saving a doc, I wanted an Input Box for the user to supply info.
Then I thought rather than having them type, I would supply a drop-down of
options.
This is not inside the document.
Thanks,
Bryan
"Russ" wrote:
Does an autotextlist do what you want?
http://www.word.mvps.org/FAQs/TblsFldsFms/AutoTextList.htm
I would like to use an INPUT BOX that rather than having a user key in
something, they would choose from a list. Is this possible?
If so how would you code?
A userform is not what I am looking for as this is not part of the
document
Thanks,
Bryan
--
Russ
drsmN0SPAMikleAThotmailD0Tcom.INVALID
--
Russ
drsmN0SPAMikleAThotmailD0Tcom.INVALID
- Follow-Ups:
- Re: Input box based upon a list
- From: Russ
- Re: Input box based upon a list
- References:
- Re: Input box based upon a list
- From: Russ
- Re: Input box based upon a list
- From: Doug Robbins - Word MVP
- Re: Input box based upon a list
- From: bryan
- Re: Input box based upon a list
- From: Russ
- Re: Input box based upon a list
- Prev by Date: Re: Input box based upon a list
- Next by Date: Re: Input box based upon a list
- Previous by thread: Re: Input box based upon a list
- Next by thread: Re: Input box based upon a list
- Index(es):
Loading