Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable sum from defined input | Excel Worksheet Functions | |||
Inserting and retaining an input variable | Excel Discussion (Misc queries) | |||
How do I use a worksheet name as an input variable to a formula? | Excel Discussion (Misc queries) | |||
With QUERY how to input a variable | Excel Discussion (Misc queries) | |||
Formulas containing variable input | Excel Discussion (Misc queries) |