MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Need help with "inputbox" function

  Asked By: Jodon    Date: Feb 15    Category: MS Office    Views: 1714

Im trying to come up with an inputbox such as:

name = inputbox("enter 1 for "Range ("c1")", enter 2 for "range

I plan to do a if statement to refer to "enter 1" or "enter 2" in a

Does anyone know the correct format for this?



1 Answer Found

Answer #1    Answered By: Adalwen Fischer     Answered On: Feb 15

How about something like:

Sub TEST()
Dim WhichOne As String
WhichOne$ = InputBox("Enter 1 for Range(""C1"") or 2 for Range(""C2"")", _
"Input required")
MsgBox WhichOne$
End Sub

Didn't find what you were looking for? Find more on Need help with "inputbox" function Or get search suggestion and latest updates.