MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Input Text

  Asked By: Gracie    Date: Sep 21    Category: MS Office    Views: 1389

I need to ask the user to input a text as the input in HTML: a msgbox
with a text data. I don´t know if I can do that with the msgbox, and I
don´t wanna create a form only for this...
Does anyone have any idea? I just need to put this text in a sheet,
and the problem is that I don´t know how to ask it for the user and
set this text for a variable or something like that...
Thanks for your helping.

Sorry by the bad English. I am Brazilian and I didn´t find a good
group in portuguese.



2 Answers Found

Answer #1    Answered By: Volney Fischer     Answered On: Sep 21

Use "InputBox"

Simple Example:

Dim sString as String

sString = InputBox("Enter a Title")

Debug.Print sString

When you run the code, an Input Box will appear allowing the user  to enter

Answer #2    Answered By: Sophie Campbell     Answered On: Sep 21

That worked. Thanks.......................

Didn't find what you were looking for? Find more on Input Text Or get search suggestion and latest updates.