Once you advanced your VBA skills and want to pass arguments like formulas and error codes, though, you’ll need to know these. Here are the options:Īs long as you declare the right variable type, you won’t have to worry about this much. HelpFile and HelpContextID are advanced parameters that let you display a link to a help file (don’t worry about these right now).įinally, Type tells Excel the type of data to send from the input box. It might be best to just leave the default values for the position, as the input box is likely to come up somewhere visible. Because points aren’t the same as pixels, it can be a bit unpredictable. You’ll have to do some experimenting if you want to find the optimum position for your input box.
The distance is measured in points from the upper-left corner of the user’s screen. The Application.InputBox parameters Left and Top are not used by VBA. Application.InputBox InputBox (also called VBA.InputBox) They are almost the same except that: Application.InputBox allows you to specify the variable type of result e.g. The Left and Top arguments let you position the input box wherever you’d like it. Confusingly there are two InputBoxes in Excel VBA. Now, however, when we enter an answer and hit OK, it’s stored in B1: When we run the module, we see the input box just like last time. Response = InputBox("What’s your favorite Spreadsheeto course?") The whole module looks like this: Sub ssFav()
We’ll put the text into a cell: Range("B1").Value = response Now that we’ve stored the data in a variable, let’s do something with it. Instead of just assigning a regular string, we’ll assign the entry from an input box: response = InputBox("What’s your favorite Spreadsheeto course?") We can fix that by combining the command for an input box with the command for assigning a value to a variable.įirst we’ll create a String variable (we’re using String because we’re planning on collecting text entries): Dim response As String In the previous example, when the user hits OK, the text that they put into the input box just disappears.
0 kommentar(er)
