I’ve had experience with Mattermost and RocketChat long back. Of course there are a multitude of options out there, from the market leaders, Slack and Teams to open source ones like Mattermost, ZulipChat and RocketChat.īut we needed more flexibility and of course, cost was an important factor, not the most, as we are willing to pay for a good solution, but we think, if there is an open source as-good product, why not give that a try. We felt we need something that can help us focus, keep chats succinct and in one place. And not to forget, heaps of forwarded stuff that’s hardly work related that keeps getting mixed up with work stuff. I mean, WhatsApp was fabulous, no doubt, but there was too much noise. Once you advanced your VBA skills and want to pass arguments like formulas and error codes, though, you’ll need to know these.Back in the earlier days of the lockdown, we needed to take our teams communications a notch higher. 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 Left and Top arguments let you position the input box wherever you’d like it. 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)
