Ask Variable

  • Thread starter Thread starter James Geisbauer
  • Start date Start date
J

James Geisbauer

Is their a way Excel can ask for information, much like the Fillin in Word
works. I would like to create a proposal that prompts for information. Any
help would be appreciated.

Jim G.
 
No, when you open a worksheet, excel would ask questions for input. For
example, "What is the effective Date". I can get WORD to do it, but I need
the the more robust calculations of excel in the proposal.
Jim
 
Hi

in vba you can use code like
Range("A1").value = INPUTBOX("Enter your name","Name")
to prompt for responses - and AFAIK there are no non-code options.
 
Just to add to JulieD's response--you can use a macro that runs each time you
open the workbook that asks the user for the date:

Option Explicit
Sub auto_open()

Dim ans As Variant

Do
ans = InputBox(Prompt:="What's the effective date?", Default:=Date)

If IsDate(ans) Then
ans = CDate(ans)
Exit Do
Else
'continue asking for a date
End If
Loop

With ThisWorkbook.Worksheets("sheet1").Range("a1")
.NumberFormat = "mm/dd/yyyy"
.Value = ans
End With

End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Back
Top