change button text colour in VBA I figure this is pretty basic - be assurred that I have search for a couple of hours without success - I think more so to do with me that available answers, so my apologies. VBA and Macros: Microsoft Excel 2010. backcolo r=rgb(255, 0,0) I noticed that your code is on the OnClick, mine is on the AfterUpdate of a combo box, and it reference's a command button on the same form, which is the command button that I want to change colors. This needs to be repeated for all 8 command buttons. To create an ActiveX control in Excel VBA, execute the following steps. As I already mentioned, with the use of VBA code, you can select a range of cells or the entire worksheet and change it to whatever case you like. We may want to highlight the font in red if the values are negative, in green if the values are positive. Create comment if cell value is larger. (only text). How to put a VBA code inside command button of excel sheet using VB. More advanced macros can display custom forms (with command buttons, text boxes, drop-down lists, etc. However, as of now this is not an issue for me, I have taken Button from ‘Form Controls’. Button color and text change on click I have created a spreadsheet with command buttons that change color when selected or deselected. Much like Microsoft Excel, VBA assumes that any text wrapped in “quotes” is plain text, whereas anything not wrapped in “quotes” is a function, procedure, or operation. It's like a simple popup box on your Excel window to show a specific message. Excel VBA and Charts. It will even change the command button text to Hide Columns and then again change it to Unhide Columns. VBA functions are built-in functions that are used in Excel's programming environment called Visual Basic for Applications (VBA). A macro is a piece of computer code, that is written from excel, using visual basic application programming language. VBA Text Box is one of the controls of the many controls of the User Form. Copy an Image with Excel VBA; Excel VBA and Charts. The idea is when you click on the command button the button caption will change or 'toggle' to match the opposite of the action just performed. If there is only an OK button, clicking the X button is the same as pressing OK. Open an excel file and open VBA editor (Alt + f11) > new module and start writing code in a sub. This Excel add-in example discusses the basic steps involved in creating a useful add-in which you can use to package your VBA procedures. However, as of now this is not an issue for me, I have taken Button from 'Form Controls'. We have to create the necessary Data Connection to Connect to SQL Server, we will be passing the values entered in the cells to the Query by the click of an ActiveXControl Command Button. I am using Office 2007 Excel. The command button is a very active control and there is always VBA code behind it. After adding Font. ActiveX Controls in Microsoft Excel. Using the code below, I was able to change the name of the command button, but the code did not work if it was in the same procedure as the command button creation code. How can I either A) insert text into different planes or B) write code. Choose 'Placement' to edit the movement of the button on the workbook page. Learn how to insert MS word tables into a slide and how to manipulate the native PowerPoint table shape. To return to the Excel file click the Excel sheet icon on the extreme left. Any help would be much appriciated. For example, in the ActiveX Controls group, click Command Button to insert a command button. So before you write the code for a MsgBox, you should insert a command button in your Excel spreadsheet. Insert a command button on the UserForm as shown below − Right click on the command button. In the code you see here I am fetching data from another worksheet to populate the data in the current sheet. I am having similar issues. External monitor plugged (and Windows set on "External screen only", so only external monitor used), turn on PC, open Excel, allow macros, click any button, it. Last modified: 2015/08/14 Create a New Commandbar with one Button. There are two Excel VBA macros in the workbook -- one that takes you to the next sheet in the workbook, and one. Change the state of a custom CommandBar button using VBA in Microsoft Excel. The second way for commenting a line in a code is using the standard VBA button for comment in the toolbar. VBA and Macros: Microsoft Excel 2010. I hope it works for you. 2 part section >> Excel VBA and User Forms. OpenForm and Docmd. Conclusion: Our today's data input showcase example was a very simplified task. The command buttons are usually placed at the bottom of the form and serve to complete the transaction for which the form has been created. If the text is in a string variable (like the ones above) a workaround I would consider is following the steps below: 1- Print the text in the word document 2- Select it 3- Cut it (or copy then. Follow these steps to. To change the caption of the labels, text boxes and command buttons, click View, Properties Window and click on each. HTTP requests can be used to interact with a web service, API or even websites. I need to ger into the embedded (activeX control) commandbutton's properties. (I can change the button's label text, I'm actually interested in renaming the button itself). In our project, we want to change the values in A1 to Item, B1 to Price, C1 to Quantity and D1 to Total. Then click on the Worksheet to add the button. Hi Stephen When I closed and reopened the workbook, the buttons now work correctly so I just had to manually delete and recreate the buttons. To create an ActiveX control in Excel VBA, execute the following steps. Change the font colour too, if necessary, to contrast with the shape's fill colour. Record a set of keystrokes 2. If Type is 0, InputBox returns the formula in the form of text; for example, =2*PI()/360. An Excel VBA code example showing how to find the last populated. As the 1 is placed in A1 the formula in the above table will produce the result for a yellow button (255,193,37). unsolved VBA: Command Buttons not showing up when looping through all objects submitted 1 year ago by pino38 So Im making a macro that searches for a specific excel file, once it finds it , the macro should open the excel file and proceed to loop through all of the pages and when it finds a certain command button in one of the pages, it will. I have used this button to create a greeting card for Christmas. The text requires a carriagecontrol linefeed so vba code such as Roy's is the normal way to go. I am using Office 2007 Excel. The button alternates between an enable and disable state when it is clicked. Code to Excel Workbook Learn to debug: Debugging VBA How To: Assign a Macro to a Button or Shape How To: Assign a Macro to a Button or Shape | Peltier Tech Blog | Excel Charts User Form Creation Create an Excel UserForm When To Use a UserForm & What to Use a UserForm […]. HTTP requests in VBA gives additional capabilities to Excel. For example, create a text box control by clicking on TextBox from the Toolbox. I had been using the form control buttons to run macros, but the boss wanted each button to have it's own, different color. Microsoft Excel desktop app is an extremely powerful tool used to manipulate, analyze, and present data. Discussion: It's not always desirable to use a standard toggle button, this code uses a single command button to demonstrate how to use an If-Then-Else statement to alternate between two different states. But same code can be written in a module as well. Microsoft Excel is a deep program rich in features and functionality. This VBA sample copies multi-line text, for instance the mailing address from an email signature, as a single line into the clipboard. I need to know how to use vba to change the caption in a command button on an excel spreadsheet. CommandButton is used to run or execute a macro or procedure. To change the command text, click the text in the box and then edit the text. How to make Command Button name dynamic in Excel? This article is talking about making the name of a Command button changed dynamically with a specified cell value changes. Either way you can see toggle button are very useful. Click 'OK' to save. ActiveX controls provide more flexible design requirements than those provided by Form controls. One of the most powerful features of Excel is the ability to write programs in Visual Basic for Applications that run "behind" your worksheets to turn Excel into a calculation-oriented development platform for creating special purpose spreadsheets which can function as applications in their own right. Here is a great way. In this example, cell A1 is being selected. CommandButton is used to run or execute a macro or procedure. Add Command Button to an Excel Worksheet Posted on August 9, 2010 by andrew walker in Excel 2003 Help , Excel 2007 Help , Excel VBA with 26 Comments This was a request from a reader who wanted to know how to add and use a command button that was controlled from a worksheet in Excel. Add Toggle Button with VBA. In Excel VBA you can assign a hot key for a command Button as well. I have tested the following code with no success: Works. How would I do this in VBA?. It's easy to do this by using the worksheet objects change event. Create Dynamic Graphs & Excel Presentation. Recall: Two ways to create a Macro in Excel: 1. Code to Excel Workbook Learn to debug: Debugging VBA How To: Assign a Macro to a Button or Shape How To: Assign a Macro to a Button or Shape | Peltier Tech Blog | Excel Charts User Form Creation Create an Excel UserForm When To Use a UserForm & What to Use a UserForm […]. I usually centre the text vertically and horizontally, and choose a bigger font size. What I am trying to do now is to use my date selector created in VBA to update the Command Text under Connection Excel to update the Query based on the cell value B3 and C3 from sheet4 which respectively acts as the From Date and To Date of information to display that falls between the date selected. But same code can be written in a module as well. But I'm still having the issue with the command button color not changing by using your code referenced: me. VBA OptionButton_Control on the UserForm. Here's how to set up check boxes. This VBA sample copies multi-line text, for instance the mailing address from an email signature, as a single line into the clipboard. Best Answer: If your command button was created from the Forms toolbar, you cannot change the button color. Also for some reason the button sometimes moves from where I hav placed it to the top of the worksheet? Any help would be greatly appreciated. Hi,Is it possible to change a button's text color using a vba code based on a certain Excel Questions; Command button caption color Command button caption. This is especially useful when you have many sheets. Using the MessageBox API, I wrote my own class to customize the button text, re-purposing some of the existing messagebox types to return which button was clicked (first, second, third). You can keep a lot of information on an Excel data entry form, but you can make it easier for your users -- and yourself -- to create tables by adding check boxes. A 4 part section >> > BUY THE BOOK OF THIS COURSE ; Option Buttons and Command Buttons. It is now quite common that you can download data as csv files. generates a custom auto-number (yyyy-0000) when a New Record button is clicked. The whole list of characteristics you can see in the "Properties" window can be set in VBA. Right click. One of the great advantages of the Userform is its interaction with Excel spreadsheets, giving it dynamism and a differentiated interface. Question asked by Jagandeep Singh on May 3, 2012 Latest reply on Oct 22, 2014 by Yong Ning. We will make a simple VBA userform in which we will ask the user to enter his name, age, and sex. Create comment if cell value is larger. Caption = “New Caption!”. I am trying to use a command button to change a cell's colour. Record a set of keystrokes 2. A toggle button is used to indicate a state, such as Yes/No or a mode such as On/Off. But I'm still having the issue with the command button color not changing by using your code referenced: me. Top 100 Useful Excel Macro [VBA] Codes Examples (Visual Basic for Applications) language. Form control command buttons are designed to run macros. IF you know Basic to Intermediate Excel VBA, you can surely find more ways to utilize this info, but is not required as I explain everything in detail. 4 part section >> A TreeView Project. Captions are those that appear on your screen. On the Developer tab, click Insert. After filling this out the data gets into the appropriate cells. Learn how to insert MS word tables into a slide and how to manipulate the native PowerPoint table shape. Choose 'Placement' to edit the movement of the button on the workbook page. Maybe someone could figure out why? Anyhow, this is what I got to work in a different procedure:. Microsoft Excel is a deep program rich in features and functionality. If you want to use a different font to display text in cells, you can changes these defaults. To change the caption of the labels, text boxes and command buttons, click View, Properties Window and click on each. I couldn't change the color of regular Excel command buttons, so I inserted pictures, and assigned macros to the picture objects. For example, if you intend to add a Command Button control at Run time using the AddCommandButton() sub procedure and you need its Click() event procedure, then you must name the procedure cmdTest_Click(). The command buttons are usually placed at the bottom of the form and serve to complete the transaction for which the form has been created. The command button is a very active control and there is always VBA code behind it. What’s an Excel Subroutine? Basically, Excel VBA subroutines are collections of code that carry out specified actions on a worksheet. Click on the label , the text box and the command button and you will see a border and resizing handles around them and the properties window will show their properties. You can also underline the text in the caption and change its color to make it appear as a hyperlink. You can see the created dynamic Text Box which is shown in the following screen shot. When you add a command button to a worksheet, Excel displays the Assign Macro dialog box and assigns a default name to the macro it will associate with the button. Here is a great way. 0 ? Excel VBA ActiveX Controls #1 Worksheet Button and Textbox - Duration:. Lost of people would either use the same template or Excel worksheet and manually select the cells to clear by highlighting them. Note: The process below will only work for Office 2010 32-bit (not Office 2010 64-bit). If the text is in a string variable (like the ones above) a workaround I would consider is following the steps below: 1- Print the text in the word document 2- Select it 3- Cut it (or copy then. Step by step tutorial that can help you learn and understand Excel and Excel VBA easily :) Online learning is not a problem. If you would like a list of these functions sorted by category, click on the following button:. It is going to be used in my works rota so all other information stays the same. With the following simple VBA code, there are lots of colors to be chosen. After inserting the ActiveX Controls Button, go to the Developer tab, and click on Properties. The above image will give you idea about what I am trying to explain. Users are then able to install your add-in, which usually provides them with a custom ribbon and modules for extended controls. They are also a great way to launch the VBA editor. A button has to do something when it's clicked. I need a command button to change colors , or text when clicked , but ideally , I'd like it's reference cell , to force the command button to change colors when there is any numerical data inserted in the reference cell. I have now successfully been drawing 3D models in AutoCAD® through Excel’s VBA. In the properties windows, select BackColor. (only text). This is a very interesting situation. If you need to hide certain columns using a button, you can use this code. CommandButton is one of the UserForm control. One is a 'form' command button control, the other is an 'ActiveX' command button and they act differently. Excel Vba Change Button Text Onclick Solved: Changing Text in Buttons I am experimenting with some buttons in my worksheets to call and activate various macros. Next, we define the string "Guru99 VBA Tutorial" in code ; So, when you click on "command button" in excel. The command button is a very active control and there is always VBA code behind it. But it was perfect or us to demonstrate: It is worth to use Excel for serious tasks and the VBA help us to create interactive form for excel dashboard. title – The title at the top of the message box. To use Excel Text to Columns to convert text to numbers: Select the range of cell(s) that you want to convert (these must not span more than one column). Then click on the Worksheet to add the button. More advanced macros can display custom forms (with command buttons, text boxes, drop-down lists, etc. 4 part section >> A TreeView Project. A 4 part section >> > BUY THE. Sort Excel table [VBA] Split values. Let's start by assigning a color to the text in A1. One functionality missing from the VBA MsgBox function is the ability to customize the button text. This post will guide you how to insert blank rows when the value changes in Excel. It's just that newer versions have more options, thus more VBA Commands to control those options. HTTP requests can be used to interact with a web service, API or even websites. ActiveX controls can be used on worksheet forms, with or without the use of VBA code, and on VBA UserForms. This entry was posted on October 17, 2008 at 6:00 am and is filed under Excel VBA, VBA. So, how can I accomplish this in a single button? Thank WiB and boaq2000 for your responses. The following is the code for the main procedure;. It will even change the command button text to Hide Columns and then again change it to Unhide Columns. VBA and Macros: Microsoft Excel 2010. To change the caption of the labels, text boxes and command buttons, click View, Properties Window and click on each. How to VBA ON-OFF Button in Excel Today, I'd like to share with your simple steps to create an on-off button in Excel. Sheets(Sheetname where button is located). In the example we are developing, related to the Userform Layout and the Userform Events, we still need to configure the command buttons and the UserForm spin button. Excel VBA and Text Files. There are other examples that you can jump to like a VBA timer like in the example here. These instructions explain how to make and use web queries for Microsoft Excel on your Mac. You put one or more text boxes on your userform and ask the user for input. Here you can also specify what icon to show and the default button. Caption = "New Caption!" Somehow in Excel 2007 using. I used the ActiveX, I should have just used the Form Control. A text box is an empty field where a user can fill in a piece of text. Re: macro to change text buttons There are two types of command buttons; ActiveX command buttons from the Control Toolbox toolbar , and Form-type buttons from the Form toolbar. Update and Delete Using Excel VBA Userform, Remove Password From Excel Using Excel VBA (Coding) or you can learn much more related tips & tricks. This document, titled "Excel/VBA - A macro to change the color of a row," is available under the Creative Commons license. etc… Change Font Color in Excel VBA - Solution(s):. MsgBox function in VBA displays a message in a window and waits for click on a button. With the VBA, buttons can invoke the macros, display the messages and perform other functions. Microsoft Excel uses some default fonts to display the names of columns and rows on a worksheet. In the Excel you should select menu\ribbon command to open VB Project or press Alt+F11. I have looked for a way of changing the font size but can't seem t find one. One is a 'form' command button control, the other is an 'ActiveX' command button and they act differently. How to Change Text Based on CheckBox Value in Excel Click the 'X' to close the VBA editor. I am sharing a simple VBA example here, which explains how easily you can insert or add a new row automatically in between existing rows in your Excel worksheet, on the click of a button. ActiveX controls can be used on worksheet forms, with or without the use of VBA code, and on VBA UserForms. Link Cell Text to a Command Button Caption September 4th, 2006, 16:13 I have created a cover sheet with various command buttons linking into the available worksheets. Write The Code. For displaying a message to the End user. (I can change the button's label text, I'm actually interested in renaming the button itself). The second way for commenting a line in a code is using the standard VBA button for comment in the toolbar. Lost of people would either use the same template or Excel worksheet and manually select the cells to clear by highlighting them. So let's see how we can see and change the properties of a control added in your excel Sheet. Best How To : The chart title can be linked to a cell, but not to a combination of text and a cell. The routines and modules run fine until I try to make a change to the command button for the last step, which is the only button on. We can also use Text to Columns feature in Excel to remove leading zeros from text formatted numbers. com , file , filepicker , interface , pick , textbox , Userform. 4 part section >> A TreeView Project. 12 part section >> Excel VBA and Charts. 5 part section >> An Excel Picture Viewer Project. Let us assume, I have a list of data (or a. Change a Different Cell using an Excel VBA Function Update Another Cell using VBA UDF Change Cell Next to the Formula Cell Prevent User from Typing into Any Cell Final Thoughts. So let's see how we can see and change the properties of a control added in your excel Sheet. If you would like a list of these functions sorted by category, click on the following button:. How the Excel VBA InputBox Works. This post will guide you how to change the color of ActiveX command button in Excel. Change the font colour too, if necessary, to contrast with the shape's fill colour. Excel and VBA offer you the ability to customize a user's interface using add-ins. The text will change depending on the position of the button. Excel VBA and Text Files. Let's start by assigning a color to the text in A1. In this tutorial, I cover everything there is to know about Excel VBA Events - with useful examples. By displaying the text box on the user form we can ask them to enter the data into the text box and data entered by the user can be stored to the worksheet with simple codes. Is there a way to change font size of Command Button inserted via Design Mode, Active X Control. Conclusion: Our today's data input showcase example was a very simplified task. 4 part section >> A TreeView Project. What I am trying to do now is to use my date selector created in VBA to update the Command Text under Connection Excel to update the Query based on the cell value B3 and C3 from sheet4 which respectively acts as the From Date and To Date of information to display that falls between the date selected. Click on the buttons to see what they do!. To make the command button run an existing built-in function or VBA function, type an equal sign (=) followed by the function name; for example, =MsgBox("Hello World") or =MyFunction(arguments). Hide specific columns. Using the MessageBox API, I wrote my own class to customize the button text, re-purposing some of the existing messagebox types to return which button was clicked (first, second, third). About this tutorial: Video duration: 39 Detecting the status of the shift key when a user clicks a command button. I will extract data from an External Excel file called MOCK DATA. I am using excel 2010 and I am a raw beginner in the use of VBA. Make sure that your video resolution is at the recommended level and that zoom in Excel is at 100%. Worksheets also has its own properties. Then click on the Worksheet to add the button. TextBoxes on userforms in Excel VBA. In this example, cell A1 is being selected. It is a Windows control containing some text, it is a small round shaped. Either way you can see toggle button are very useful. Before I show you the VBA code for it and how the MsgBox looks, here is a table that lists all the different button constants you can use. Text no longer seems to work. I've pasted a command button into a sheet and it came in with a default name of "Button 1". Preventing the Button from Resizing with Cell Changes. I wonder if anyone can help with this one. Ongoing tutorial - First part is here: Part One. If you need to hide certain columns using a button, you can use this code. To perform the search you will need to enter a value (this search is based on the student number primary key) into the unbound text. As we can see, Excel provides a few of colors in the Properties dialog box for us to apply. VBA-Excel: Create or Add Worksheets at the Run time. Sub Hide_C() Dim C_ell As Range. Code works fine but everytime I select a command button the font decreases. Autohotkey runs Excel VBA macro but changes are not applied Change ActiveX Command button color back to previous. Command Buttons in VBA for Excel. Update and Delete Using Excel VBA Userform, Remove Password From Excel Using Excel VBA (Coding) or you can learn much more related tips & tricks. With the VBA, buttons can invoke the macros, display the messages and perform other functions. Label is one of the UserForm control. value = "Text Example" [/code]Cells (Row 4, Column 2) With Cells you first enter the row n. A 4 part section >> > BUY THE. 4 part section >> A TreeView Project. buttons – Choose which buttons to display. InputBox method) using macros with this step-by-step tutorial. In the toolbox the command button has this icon. I am trying to use a command button to change a cell's colour. Lost of people would either use the same template or Excel worksheet and manually select the cells to clear by highlighting them. In the properties windows, select BackColor. Hello,Can someone advise me of the correct syntax for changing the caption of a Command Button in MS Excel, please? I have tried this in a function, but it does not work: ActiveSheet. Change the state of a custom CommandBar button using VBA in Microsoft Excel. Very very basic Excel skills needed for this course. Command Buttons in VBA for Excel. I am wondering if there is a way similar to what can be done using Javascript to have one button which serves two purposes. On the Developer tab, click Insert. You create and access these UserForms in the Visual Basic Editor. How to assign a VBA Macro to change the color of ActiveX command button in Excel. Hide columns using a button. To make the command button run an existing built-in function or VBA function, type an equal sign (=) followed by the function name; for example, =MsgBox("Hello World") or =MyFunction(arguments). The Control toolbox will appear, just as it does on a UserForm within the VBA editor. Change the Name of the Command Button to "SubmitButton" and change the caption to "Submit". Command Buttons in VBA for Excel. Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac More Less You can use a Form control button or a command button (an ActiveX control) to run a macro that performs an action when a user clicks it. You may have to register before you can post: click the register link above to proceed. In Excel 2003, and earlier versions, where there is a Menu Bar, the SendKeys could simulate a keyboard shortcut to run a menu command. Use a Command Button to change a specified cell value with VBA code Combine multiple worksheets/workbooks into one worksheet / workbook:. When you work with VBA macros in Excel, you often need user input via a userform. Fortunately, Excel lets us refer to an ActiveX control on a worksheet by using its name, without reference to the OLEObjects collection. 6) Using Excel’s Text to Columns feature. If they are not enabled, follow below steps. I've pasted a command button into a sheet and it came in with a default name of "Button 1". Notice how all my example Option Button's have the exact same text as the headings in my data. Text no longer seems to work. As we can see, Excel provides a few of colors in the Properties dialog box for us to apply. We will make a simple VBA userform in which we will ask the user to enter his name, age, and sex. About this tutorial: Video duration: 39 Detecting the status of the shift key when a user clicks a command button. In the toolbox the command button has this icon. generates a custom auto-number (yyyy-0000) when a New Record button is clicked. IN the exercise below you will double click on the command button to see its VBA code. 4 part section >> A TreeView Project. The button will then be in Edit mode. The inserted code automatically hooks up with the already available code by matching procedure arguments with available variables. This Excel add-in example discusses the basic steps involved in creating a useful add-in which you can use to package your VBA procedures. Shapes(name of the button). It is going to be used in my works rota so all other information stays the same. Struggling to change the caption of a command button in excel (2007) using VBA? Try the following code: Application. Create Form Control Buttons Dynamically On A Worksheet With VBA Occasionally developers need to dynamically create buttons on a worksheet that are linked to a macro. Change the Button Text. Add Toggle Button with VBA. When you drag a Button from Form Controls, there is a pop up message asking you to assign a Macro to the Button. Resizing Excel Radio Button's Font Tips about Microsoft Excel VBA programming to ease your business day. In this example, cell A1 is being selected. In Excel 2003, and earlier versions, where there is a Menu Bar, the SendKeys could simulate a keyboard shortcut to run a menu command. I have created a command button but when I make the button smaller cannot see the text on the button. Change caption of command button using code If this is your first visit, be sure to check out the FAQ by clicking the link above. It can be text (e. Hello,Can someone advise me of the correct syntax for changing the caption of a Command Button in MS Excel, please? I have tried this in a function, but it does not work: ActiveSheet. Learn how to create ActiveX controls such as command buttons, text boxes, list boxes etc. Use a Command Button to change a specified cell value with VBA code Combine multiple worksheets/workbooks into one worksheet / workbook:. Shrinking text size when using VBA command button on a form Inserted command buttons from VBA toolbar into my Excel user page and have associated code with the buttons. Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac More Less You can use a Form control button or a command button (an ActiveX control) to run a macro that performs an action when a user clicks it. Sub Hide_C() Dim C_ell As Range. Write The Code. I am using excel 2010 and I am a raw beginner in the use of VBA. Excel has two choices for the same control. Despite what others say, it is possible to change another cell with a VBA user-defined function. To create an ActiveX control in Excel VBA, execute the following steps. To perform the search you will need to enter a value (this search is based on the student number primary key) into the unbound text. Dowload from Rob Bovey's site. I cannot figure out where in the interface to go to change the button's name. You may have to register before you can post: click the register link above to proceed.