I’m trying to run a macro that will have a default value that is not on
the active sheet…
FlowAdjust = Application.InputBox(“Enter the desired setpoint for PIC340 (0 to 800 psig)”, [“LN2 Pressure”], Range(“LINX N35!B12”))
I get a: Method ‘range’ of object’_global failed error.
If I remove the ‘Range(“LINX N35!P4”)’ section it works fine.
I would like the default number in the box to come from another sheet that has the current value so that someone does not accidentally themselves.
So the first input to the application.inputbox is the setpoint, second is the value from the data sheet, and the third is a present status from the basic?
I do not use basic. Just DDE, RSLinx and excel.
It opens a dialog box and asks for the set point. I’m just trying to get the box to open with the current set point already present.
I just don’t know the syntax to link it.
The InputBox function syntax has these named arguments:
Part Description
prompt Required. String expression displayed as the message in the dialog box. The maximum length of prompt is approximately 1024 characters, depending on the width of the characters used. If prompt consists of more than one line, you can separate the lines using a carriage return character (Chr(13)), a linefeed character (Chr(10)), or carriage return–linefeed character combination (Chr(13) & Chr(10)) between each line.
title Optional. String expression displayed in the title bar of the dialog box. If you omit title, the application name is placed in the title bar.
default Optional. String expression displayed in the text box as the default response if no other input is provided. If you omit default, the text box is displayed empty.
xpos Optional. Numeric expression that specifies, in twips, the horizontal distance of the left edge of the dialog box from the left edge of the screen. If xpos is omitted, the dialog box is horizontally centered.
ypos Optional. Numeric expression that specifies, in twips, the vertical distance of the upper edge of the dialog box from the top of the screen. If ypos is omitted, the dialog box is vertically positioned approximately one-third of the way down the screen.
helpfile Optional. String expression that identifies the Help file to use to provide context-sensitive Help for the dialog box. If helpfile is provided, context must also be provided.
context Optional. Numeric expression that is the Help context number assigned to the appropriate Help topic by the Help author. If context is provided, helpfile must also be provided
Trying to get the default part, to come from another sheet.