The easiest and most common way to interact with users when making VBA macros is by using InputBox and MessageBox. Insert a command button, and right click, then choose View Code from the context menu, see screenshot: 2. Using conditions will direct the macro execution in a certain direction, depending on the test and the inputs. To launch the VBE, click on tools on the menu bar and select macro and then click on Visual Basic Editor. Arrays are used to group similar data together, to make it easier to search and sort through this data. From the Office Button menu, press the button Excel Options. If you have two or more option groups on the same worksheet, use a different linked cell for each option group. Since this will be a building block for the next case where the names are not known in advance, we will use an array data structure. Re: VBA code for Option Button choices on Userform Again, a workbook would resolve this much more quickly, the absence of which is shooting in the dark a little. An Option Group is a frame containing a collection of control buttons. However, two or more option buttons must work together because as one of the option buttons is selected, the other option button will be deselected. The Buttons argument is a value of the VbMsgBoxStyle enumeration. 6 thoughts on " Better Option Button Controls " Chris Macro November 30, 2015 at 7:02 am. The controls used in AutoCAD VBA are a bit different from those used in MS Access, where data binding is heavily used. Useful Functions for Working with Arrays in VBA The Array function is an easy way to create and fill an array with values. Onkey you can disable a particular key or key combination or run a macro when you use a particular key or key combination. Whenever one is pressed, I want to invoke code to action the following: change forecolor of non-selected option buttons to yellow change forecolor of the selected option button to red. Your VBA programs will usually be self-contained and run just fine on their own. Purpose and Features. Array Names and Matrix Functions in Microsoft Excel ®. Note that VBA allows lower bounds of arrays to start at either 0 or 1 by default, as governed by an Option Base statement at the beginning of a VBA module. If you don't have it installed you can install it by Control Panel-> Add/Remove Programs-> select your Office version-> button change. Visual basic tutorial problems, developed by Dr. If you are not familiar, read the tutorial VBA Excel Form Control & ActiveX Control. There may yet be new life for the old Wapato Detention Facility in North Portland. For example: I have four Option/Radio buttons on Worksheet 1 labelled Alpha, Bravo, Charlie, and Delta. 1 - 1D Arrays (vectors) - Duration: 11:27 Learn Visual Basic 6. and walk over to the TV to press a button. I have a series of 12 option buttons on my spreadsheet named Opt_1 thro' opt_12. We work dir. So, I would give those 4 option buttons the same name and then give them each a unique index (say 1 to 4). If you have independent Yes/No options, use CheckBoxes instead. Option groups may apply to toggle buttons, checkboxes, or radio buttons and work well if you don’t have a lot of options from which to choose. This tutorial will explain how to find a value in an Excel column using the Find function in VBA. Arrays are extremely useful in Visual Basic, and are present in many other programming languages. A user may. The only problem I would like to point out is there will be a problem if there are any gaps in the array of option buttons. Excel VBA MsgBox: Step-by-Step Guide and 19 Examples to Create a Message Box with Macros. Formularios VBA – Uso y propiedades del ListBox Formularios VBA – Uso y propiedades del CommandButton Uso de formularios para el registro de datos estudios en el exterior ¿Qué es el OptionButton en VBA y cómo se usa?. Please find more details about VBA ActiveX Option Button Control on the UserForm. The main guideline for radio button design is to select one of the radio buttons by default (i. But, as u know, I don't know how to create an array to contain my buttons without creating new buttons. How to make an array of buttons in Visual Basic programmatically. So only one station can be selected at a time. Windows FileDialog to Select File or Folder Path in VBA Dear friends, In my many of the Excel Tools, wherever there is a need of file path to be entered from your local PC, I try to put a browse button to locate that file in your Windows PC through windows file explorer window. The RadioButton control has the same behavior. One of the more noticeable changes for a Visual Basic 6. 1 - 1D Arrays (vectors) - Duration: 11:27 Learn Visual Basic 6. So Im having a bit of trouble coming up with how to do this. In the ActiveX Controls group, click Option Button. How to make an array of buttons in Visual Basic programmatically. This is a demonstration of a convenient feature of the Excel spreadsheet that is not well documented in the online help files. MSDN Visual Basic Community : Title: See which option button is selected using Select Case: Keywords: Select Case, option, control, select. If you are not familiar, read the tutorial VBA Excel Form Control & ActiveX Control. With the following simple VBA code, there are lots of colors to be chosen. VBA Array Function Example. So Im having a bit of trouble coming up with how to do this. If you're familiar with array formulas, you'll be happy to know that you can create VBA functions that return an array. Below is a list of Excel VBA functions sorted alphabetically. Every group has 5 Radio button. The VBA editor does look slightly different in Excel for Mac, but also has the same functionality. How to use ActiveX control in VBA. Definition and Syntax of VBA Split Function: Split can be defined as a function that can split a text string into an array, by making use of a delimiter character. In the toolbox the option button has this icon , the check box has this one and, the frame this one. In this case, MsgBox is called with only one argument. TextBox An Event macro that will change all text boxes on the worksheet to caps upon selection of the worksheet. htm) Create a new sheet named with the text value of a cell with a changed value in Column F (col 6). Such radio buttons appear and behave as a group. You can store all kinds of elements in a variant variable; amongst them an array. In the second section you have learned many useful VBA words (code). If you want it to remain checked then need not include this event Private Sub Form_Load(). Use an Option button in a Userform In VBA, you can create an Option button to enable a user to choose from several option. So that your buttons are treated as a group, return to your form in the VBA Editor and click on the YES option button. NET, C#, Visual Basic, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft. Why would you need to use an array? Well, suppose you wanted to store twenty employee names in variables to use in a procedure. For example, in a ComboBox, the Drop Button is a small button with an arrow; when clicked this Drop Button drops down a list of options for the user to select from. In VBA a normal variable can store only one value at a time. OptionB utton") Now i have to use this control array in this " commandButton_Click ". MSDN Visual Basic Community : Title: See which option button is selected using Select Case: Keywords: Select Case, option, control, select. The PasteSpecial VBA Command: Get VBA to Do the Hard Work for You March 27, 2014 by Richa VBA or Visual Basic for Application is an integration of Microsoft’s VisualBasic with MS office applications such as MS Excel. We'll get into this further. Add("MSFor ms. In general one variable is supposed to hold a single value at a time, but when we want to store multiple values in a single variable then such type of variable is known as array variable, to use an array variable in VBA we need to declare or define it first, we can define the array variable with its length or without its length. The VBA interoperability project is a joint Novell & Sun incubator project whose aim is to deliver a way to run Excel and Word macros natively in imported documents. This button enables you to find and select one or more members with options to find next, find previous, check all found members, or clear the entry field. Here, of course, I've implemented my own approach to deal with colors using an array where the lower the index, the lighter the tone of that color is, but you could design whatever you want. Excel VBA Tutorial Chapter 3: Condition statements Goal of this chapter. Providing the full piano complement of 88 keys, The Q88 is a sleek and portable controller, at home on stage or in the studio. But, as u know, I don't know how to create an array to contain my buttons without creating new buttons. 12/06/2017; 28 minutes to read +6; In this article. What is option button in visual basic? 7 8 9. Note: This section assumes you are familiar with the process of creating an interface in excel. net A RadioButton control provides a round interface to select one option from a number of options. The easiest and most common way to interact with users when making VBA macros is by using InputBox and MessageBox. While SELECT is most useful within a FORM, HTML 4 allows SELECT in any block-level or inline element other than BUTTON. For example, drop-down boxes, list boxes, spinners, and scroll bars are useful for selecting items from a list. The Buttons argument is a value of the VbMsgBoxStyle enumeration. Islamic kingdom of God on Earth, Understand the mind of the Jihadist, Leftist/Marxist, Islamist Alliance, Sharia Law, America, Liberal Islamic alliance, war. NAME SURNAME * EMAIL * SUBJECT * PHONE NUMBER * COUNTRY * INQUIRING FOR * Web Design Offers Question Other. In the VBA Editor, a VBA module when viewed resembles and behaves like a Word document in both basic organization and typing. In this tip we will learn about passing parameters from Excel cells to a Query at run time to import the data from SQL Server using Visual Basic. VBA functions are built-in functions that are used in Excel's programming environment called Visual Basic for Applications (VBA). htm) Create a new sheet named with the text value of a cell with a changed value in Column F (col 6). A condition statement is a test if a certain condition is met or not. Microsoft Office Add-ins and Consultancy. But, as u know, I don't know how to create an array to contain my buttons without creating new buttons. It links your macro code and creates a button in the ‘Insert’ menu that will run the code recorded by the macro recorder. In JavaScript, creating a group of like objects, known as arrays, is possible using this same concept. The VBA MsgBox function. I have two option buttons on each of five spreadsheets in my Excel workbook. Re: Guide for vba Radio buttons Please check the image. How to return multiple values from a VBA function (Part 2) Part 2 - Using array, CSV, and user-defined type. You should use arrays when a related set of values is to be stored in a variable. simply make use of a Control array (technically not allowed in. Sometimes, developers are in a position to hold more than one value in a single variable at a. Lesson 31 on Excel macros (VBA): Option Buttons, Check Boxes and Frames. Array Functions. If you plan on typing the macro without using the macro recorder, you can choose Insert, Module from the VBA menu. In Excel VBA you can move certain columns of your choice with the help of VBA. Using Objects in VBA VBA Arrays VBA Collection VBA Dictionary VBA Workbook VBA Worksheet. We provide extraordinary vision and dental benefits, the best group coverage options, and outstanding service for our members. On the page Arrays and ranges I described how you can get considerably faster code (for some tasks) if you copy a range to an array, manipulate the data in the array and then paste the array as a table in one swift operation. Drag two option buttons on your worksheet. AutoHotkey is a free, open-source scripting language for Windows that allows users to easily create small to complex scripts for all kinds of tasks such as: form fillers, auto-clicking, macros, etc. You should use arrays when a related set of values is to be stored in a variable. The MessageBox Builder allows you to quickly design. Loupedeck announced a new editing console for creative work called the Loupedeck Creative Tool. So Im having a bit of trouble coming up with how to do this. The following VBA code creates an array of three Integer values. In this section, we will see how to incorporate 'commandclick' button in VBA and execute a program using the button. Using Option Explicit forces you to declare all your variables. Visual Basic. Excel VBA Topic 9. Most people don't put enough effort into designing their surveys - sloppy designs, messed up document structures or simply frequent typo's and misspelled questions. Now we will see the option of the message box button. And if accidentally the user left uncheck any group of radio buttons,the back ground color of that group must change to red and as well as a warning message appear. Go To Developer Tab and then click Visual Basic from the Code or Press Alt+F11. The array values are refreshed when you click OK or Apply to close the dialog box or task pane, even if no changes are made to function arguments. These values should be separated by commas. The maximum length of ‘Text_String’ is 1024 characters. The controls used in AutoCAD VBA are a bit different from those used in MS Access, where data binding is heavily used. 0 (Visual Basic Tutorial - 13) Form Design: Create a form with 3 text boxe , 3 Label , 4 Option Buttons And 3 command button. Visual Basic 4. Both the buttons always remain together but function separately. There may yet be new life for the old Wapato Detention Facility in North Portland. Includes: Creating, Deleting, Populating, etc. ) but for now I'll just show how to loop through them. Every group has 5 Radio button. There are many ways to achieve the same task, for instance a Quiz Show can be simulated in many different ways & without using VBA. Also, can be specified via data-attributes. Drag two option buttons on your worksheet. 12/06/2017; 28 minutes to read +6; In this article. You have an ActiveX Control that runs on a click event. You will learn to create the different types of Excel VBA (Visual Basic for Applications) Variable Data Types. One website for all Microsoft Office users and developers. In this image Seven groups of radio buttons. This can lead to issues when BIGINT's are used (e. For example, an array may consist of the number of students in each grade in a grammar school; each element of the array is the number of students in a single grade. Lest you think VBA is something esoteric which you will never. In my system the buttons are hard to see from my chair. 0- Frame Control,Check Box and. Add a command button to the sheet. To correct this problem,first save the VBA customization and then shut down the VBA editor. If you are not familiar, read the tutorial VBA Excel Form Control & ActiveX Control. Calculate or Application. The 2020 Audi A1 Sportback will be launching Down Under next month, with the German marque detailing pricing and specifications for its three-tier compact hatchback range. An array is a set of values, which are termed elements, that are logically related to each other. Specifically, the user can select only one option at a time. NET and its associated languages. How to make an array of buttons in Visual Basic programmatically. Ongoing tutorial - First part is here: Part One. Instead of having to type an answer to a question, just click on one of the buttons, to make a choice. Here, of course, I've implemented my own approach to deal with colors using an array where the lower the index, the lighter the tone of that color is, but you could design whatever you want. Step 3: Access Outlook VBA Editor. Put the Select Case in the Click event of the Option button like this: Private Sub OptionButton_Click(Index As Integer) Select Case Index Case 1 '--- Code for Option. I found it easy because VB6 allows you to create an array. VBA JSON Parser. How to Avoid the Select Method in VBA & Why. The MsgBox enables creating dialog boxes with many options. As you add more OPTION buttons they are all linked to the same cell. I've created a userform that will require an option button to be selected (thus emailing the intended recipient), otherwise it will display a msgbox. For example, an array may consist of the number of students in each grade in a grammar school; each element of the array is the number of students in a single grade. When you add an option button, the GroupName property is set to the worksheet's name. ez beb et b. Please find more details about VBA ActiveX Option Button Control on the UserForm. The Find function is one of the most common functions used in VBA. The band and the case are. ChoiceType Field (select drop-downs, radio buttons & checkboxes)¶ A multi-purpose field used to allow the user to "choose" one or more options. And then, you click the button "Run Macro" in the toolbar. Re: VBA code for Option Button choices on Userform Again, a workbook would resolve this much more quickly, the absence of which is shooting in the dark a little. The Syntax of VBA Split Statement is as follows: Split (text_string, delimiter, limit. I have two option buttons on each of five spreadsheets in my Excel workbook. SelectionBox dialog for simple selection in VBA macros. x databases. Coding an Option Button Control Array. Also, can be specified via data-attributes. An Option button is often used in Userforms, but can also be used in a Worksheet. 0 was released in the summer of 1993 and came in Standard and Professional versions. This means that all option buttons added to a worksheet will work as one unit if you don't change the GroupName. Best Way To Get Rid Of ForwardOpen from Windows System Assistance For. Code for calling a message box with the option Yes or No and depending on the answer different coding is executed. Option Base is used to declare the default lower bound of array elements. Now setup will start. As soon as you select it, it gets a black dot in. Here's how to calculate survey scores with Excel Option Buttons. I suggest staying away from the registry, but there's no reason to use stream reader/writers as the. CheckBox to give the user an option, such as true/false or yes/no. Copy an Image with Excel VBA; Excel VBA and Charts. ) but for now I’ll just show how to loop through them. I found this was more suitable as it allowed. One, create a Pie chart on your own using the tools available or you can use VBA to create Pie charts automatically with the click of a button. VBA loop group of buttons on UserForm. NET Visual Basic is no longer supported or updated by Microsoft, the VBA programming language was upgraded in 2010. In this tutorial, you will learn how to create an Option button, get a user choice in VBA and use it in code. This tip has been written for CorelDRAW® Graphics Suite X3. I've created a userform that will require an option button to be selected (thus emailing the intended recipient), otherwise it will display a msgbox. Arrays (arrays. Locking bound controls. Add("MSFor ms. of the downloadable Tutorial on Excel macros. Now you can see the difference in the title of the message box. So today we will launch two ways to insert VBA Button in Excel. 0 and for Microsoft Excel and Microsoft Access Programming (when done with VBA), however, I've only made sure that they work in VB6. Most programming languages support arrays, including VBA. We work dir. In VBA, a dialog box can be created by using the MsgBox function. com ' ' This module contains procedures that provide information about and manipulate ' VB/VBA arrays. But you didn't mention what type of textbox you were referring to, so I will assume that you meant the ActiveX TextBox control that is on the Controls toolbar for use on userforms. The user may only select one Option Button per "group", which is not the case with checkboxes. GoTo selects any range or Visual Basic procedure in any workbook, and activates that workbook if it’s not already active. An Option Group is a collection of Option Buttons (sometimes called Radio Buttons) placed within a Frame (in fact option buttons on a VBA UserForm do not need to be placed within a frame to work as a group, but it helps the user to understand that they work together). In this post I am going to show you how to populate an array with Excel VBA. Array Functions. What is option button in visual basic? 7 8 9. Arrays are convenient and they simplify program code tremendously. You can use this method to search in a sheet, or part of a Microsoft Excel spreadsheet. Please find the following steps and example code, it will show you how to add dynamic list box control on the userform. I need to iterate through a array each time i click a button. Calculate and display the average of the three array values as before. VBA offers two options: to declare the array as a Variant variable or as an array variable. I say this not because I am waving a banner for traditionalism, or even for consistency. Ongoing tutorial - First part is here: Part One. An Option button is often used in Userforms, but can also be used in a Worksheet. To call a message box with the option Yes or No and depending on the answer different execute different sub programs is good when trying a more interactive approach with the end-user. Excel has two type of controls: Forms and Active-X. The VBA MsgBox function is used to display messages to the user in the form of a message box. Since this will be a building block for the next case where the names are not known in advance, we will use an array data structure. The macros would copy all the data in the text file to the clipboard and then use the Paste Special command with the column type as US English and paste the data into my. (install with right on sheet tab, view code, ) Private Sub Worksheet_Activate() ' change all textboxes on the page to caps ' upon worksheet activation. If you have two or more option groups on the same worksheet, use a different linked cell for each option group. In this post I will create an Inputbox for users to select options with the help of Select Case. Sometimes, developers are in a position to hold more than one value in a single variable at a. Another tool of Excel VBA is the ‘Button’. When you add an option button, the GroupName property is set to the worksheet's name. Editor form the ribbon or by pressing the Alt+F11 buttons. While GetSelectedOptionIndex shows a handy method to retrieve the index of the selected item when using an option button control array, due to the hard-coding of the control array name the method is restricted to just that control array. Expert Tip: If you are a VBA newbie then learning about VBA message box can be a good idea. Visual Studio Languages , Visual Basic https:. 2 CALCULATIONS WITHOUT VBA 3 1 Introduction Visual Basic for Applications, Excel’s powerful built-in programming lan-guage, permits you to easily incorporate user-written functions into a spread-sheet. The macros would copy all the data in the text file to the clipboard and then use the Paste Special command with the column type as US English and paste the data into my. Klipfolio Partner Certification Exam Answers. Option #1: Ctrl+Left-click to Select Multiple Cells. Code for calling a message box with the option Yes or No and depending on the answer different coding is executed. Learn how to build 10 Excel VBA applications from scratch. The method allows users to locate the first occurrence of a piece of information within a range. Please subscribe for more visual basic programs Skip navigation Option Button In VB 6. Useful Functions for Working with Arrays in VBA The Array function is an easy way to create and fill an array with values. This is a demonstration of a convenient feature of the Excel spreadsheet that is not well documented in the online help files. Using this technique when a form contains many option control arrays requires a separate procedure for each. View button: This button enables you to select whether to display members in the member list as a hierarchy or as dynamic time series members. Visual Basic 3. How to Check if an Array is Empty in Excel VBA Posted on September 12, 2012 by andrew walker in Excel 2003 Help with 0 Comments When using Arrays in Excel VBA you sometimes need to test whether the array is empty or not. In this sample, you will learn how to create a button that will refresh your SAS content. While Yamaha's THR line features a rechargeable battery. 01 for Windows by developing a global text editor. software-solutions-online. NET code won't work for them. I want to bound the user to check every group of option buttons. 1 Creating Excel VBA Using the Command Button. It does this by evaluating the output of the choose an option area (the optgrpChoice control). And if accidentally the user left uncheck any group of radio buttons,the back ground color of that group must change to red and as well as a warning message appear. Command buttons appear in almost every window of every Windows application. I have these working quite well. If qualified with the type-library name, Array is unaffected by Option Base. CONT Command Resumes the execution of the program which has been stopped. Visual basic tutorial problems, developed by Dr. Excel VBA (Visual Basic for Applications) is where spreadsheets meet programming. Bootstrap options for modal. Your VBA programs will usually be self-contained and run just fine on their own. To create an Excel VBA macro using the command button, you need to place it on the spreadsheet. Setting Microsoft Access VBA Module Options Properly Option Settings in the Declarations Section of Modules and Classes. So, I would give those 4 option buttons the same name and then give them each a unique index (say 1 to 4). Now we will see the option of the message box button. Here you will see (almost) all of the options available to you when creating message boxes. In this example I’m going to show you how to create a previous and a next button in a userform in the Microsoft Excel using VBA. Change the color of ActiveX Control button with VBA code. Click on the “Exit design mode” option and then click on your button to run the code. Boss' latest Katana offerings simulates 10 different amp models and 60 effects. Includes: Creating, Deleting, Populating, etc. The 2020 Audi A1 Sportback will be launching Down Under next month, with the German marque detailing pricing and specifications for its three-tier compact hatchback range. What is the VBA Dim Statement. I suggest staying away from the registry, but there's no reason to use stream reader/writers as the. Best Way To Get Rid Of ForwardOpen from Windows System Assistance For. The process of adding can be controlled based on different condition required. Arrays are great way to quickly gather data, put it into Excel's memory and then manipulate this using VBA code. Once the form has been submitted, we will enter data into the cell that corresponds to the column numbers and row. and walk over to the TV to press a button. In the subsequent screen, you should select “Notifications for all macros” and hit “OK” button. Klipfolio Partner Certification Exam Answers. 6 thoughts on " Better Option Button Controls " Chris Macro November 30, 2015 at 7:02 am. You have an ActiveX Control that runs on a click event. This article inroduces a third dialog, the SelectionBox. Instead of the default title Microsoft Excel now it is showing Introduction to VBA as the title of the message box. Tags: RadioButton, VB. So it does not matter if you have 16 or 43. So today in this post, I'd like to share with you all the details about using a message box in Excel and some of the real life examples. Excel Macros Section 3: Userforms. 4 million new cases were diagnosed and 694,000 deaths were. To start off, I initialized the array. NET, Radio button control, VB. so my variable bFacility(0) gets assigned to the status of the fourth (4th) radio button (Radiobutton5) I don't know how to make them the same sequence. VBA UserForm Controls with Drop Buttons. How to Create a VBA Message Box in Excel (“msgbox”) for Non-Geeks. The position listed below is not with Rapid Interviews but with FLIR Systems Our goal is to connect you with supportive resources in order to attain your dream career. Option buttons tend to work as a group. Using this technique when a form contains many option control arrays requires a separate procedure for each. In the toolbox the option button has this icon , the check box has this one and, the frame this one. This solution locks only the bound controls on a form and handles its subforms as well. In this chapter we will review the use of the following Excel VBA elements: Arrays. They are essentially the same in terms of set-up. Ongoing tutorial - First part is here: Part One. If you want to run a sub, which doesn't return a value, do not include the ? and just enter the subroutine name: MsgBox "Choose a. Backus-Naur Form JSON Parser based on RegEx for VBA. At the same time, the applications and capabilities of VBA. Re: VBA code for Option Button choices on Userform Again, a workbook would resolve this much more quickly, the absence of which is shooting in the dark a little. Right click on the command button, click properties; Change the command button caption to ‘Create_Listbox’. Visual Basic allows any variable type to become an array. NET is the automated creation of control arrays by simply copying an existing control as many times as required into an array. TextBox An Event macro that will change all text boxes on the worksheet to caps upon selection of the worksheet. How to Use Excel VBA Variable Data Types. Option groups may apply to toggle buttons, checkboxes, or radio buttons and work well if you don't have a lot of options from which to choose. When Option Explicit appears in a module, you must explicitly declare all variables using the Dim, Private, Public, ReDim, or Static statements. Excel VBA (Visual Basic for Applications) is where spreadsheets meet programming. Learn how to use all Excel VBA functions used in Macros. vba documentation: Option Base {0 | 1} Example. With Application. In my system the buttons are hard to see from my chair. This tip has been written for CorelDRAW® Graphics Suite X3. The SelectionBox dialog contains a listbox and Ok and Cancel buttons. 4 part section >> A TreeView Project. I have used this button to create a greeting card for Christmas. I had a trial before to write phone index program using VB6. The option buttons are as follows OB1,OB2,OB3, & OB4. 1 Creating Excel VBA Using the Command Button. An example would be storing a list of countries or a list of weekly totals. Manipulating Selection Set with VBA 1 May, 1998 By: Bill Kramer This month, we continue our journey into Visual Basic for Applications (VBA) and explore how to use it with AutoCAD R14. It returns a zero-based, one-dimensional array holding the parts of the original text string. Every group has 5 Radio button. Using Arrays in Outlook macros. It provides Excel VBA tutorials on how to create statistic estimates that are used to analyze the data from a simulation. This demonstration is merely an indication of how it could be done.