Logo 
Search:

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: 834
  

Im trying to come up with an inputbox such as:

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

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

Does anyone know the correct format for this?

Share: 

 

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.




Tagged: