MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Input Text

  Asked By: Darla    Date: Feb 07    Category: MS Office    Views: 1963

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.



1 Answer Found

Answer #1    Answered By: Chuong Tran     Answered On: Feb 07

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

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