Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Input Text

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

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.

Share: 

 

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
something.

 
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.




Tagged: