View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
buggy buggy is offline
external usenet poster
 
Posts: 1
Default Input box with variable


I'm trying to include a variable in the text of my Input box so that th
user knows what was entered the previous month.

Here is the code I am using so far but I can't get the synta
straight:

Dim Data
Data = InputBox("Please enter this month's WAN Availability. Las
month's Availability was " & 'Data Input'!C40, "New Month Data")

Sheets("Data Input").Range("C41") = Data

Help

--
bugg
-----------------------------------------------------------------------
buggy's Profile: http://www.excelforum.com/member.php...fo&userid=1666
View this thread: http://www.excelforum.com/showthread.php?threadid=31874